How to keep the same cell reference

When you need to perform a formula that requires you to reference the same cell whilst moving down or across. You will need to lock the cell reference by using $ Dollar signs.

To create Absolute cell referenced cells you will need to use the $ or press F4 on a Mac Command T.
For more tips and tricks in excel follow my YouTube Channel Analir Pisani  or visit our web site


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s