To quickly ad the $ symbol around your cell references simply select the cell references in the formula bar and press f4. For example, if you have =A1 in the formula bar and you highlight and then press f4, the result will be =$A$1.

A quick way to create an absolute cell reference.

Joseph Harris
Analyst Resources

Related posts:

  1. ABS Function, Absolute Value in Excel ABS can be used to display the absolute value of...
  2. Excel Concatenate Function The Excel concatenate function can be used to combine multiple...
  3. #VALUE! Error in Microsoft Excel The #VALUE error is an error that is seen almost...
  4. Excel CELL () Function The CELL function can be used to find out information...
  5. Conditional Formatting Q: Dear ExcelYogi, Thank you for all your wonderful advise...

This entry was posted on Thursday, November 20th, 2008 at 10:13 am and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “F4 Function Key in Excel”

  1. Jon Peltier on November 20th, 2008 at 12:48 pm

    You should mention that pressing F4 repeatedly cycles through the possible combinations of absolute and relative references:

    then back to A1

Leave a Reply

You must be logged in to post a comment.