Excel: Toggle between relative and absolute cell references


SS-2010.08.26-08.47.54Knowing the difference between and properly using relative and absolute cell references can be extremely helpful when putting together a spreadsheet.

Some background on relative and absolute references: http://www.cpearson.com/excel/relative.aspx

There is a quick and easy way to toggle between the two when entering a formula:

  1. After entering a reference in a formula, hit the F4 key to change to an absolute reference.
    1. Hitting the key once will make both the row and columns references absolute
    2. Hitting again will make only the row absolute
    3. Hitting a third time will make only the column absolute
  2. Hit enter to complete the formula.

You can also perform this function while editing any existing formula/reference.

Advertisements
  1. #1 by http://52diet.org/feed/ on March 25, 2013 - 11:40 am

    Hello there! Do you know if they make any plugins to protect against hackers?
    I’m kinda paranoid about losing everything I’ve worked hard on.
    Any recommendations?

  2. #2 by Lynda on May 10, 2013 - 3:57 pm

    Every weekend i used to visit this website, as i want enjoyment, for the reason that this this site conations actually pleasant funny material
    too.

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

%d bloggers like this: