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 www.azsolutions.com.au

Advertisements

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: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
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:

WordPress.com Logo

You are commenting using your WordPress.com 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