• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Working with Formulas > Creating an Absolute Reference in a Formula

Creating an Absolute Reference in a Formula

Occasionally when you copy a formula, you do not want one of the cell references to change. That’s when you need to create an absolute reference. To indicate an absolute reference, use the dollar sign ($).

It’s called an absolute reference because when you copy it, it absolutely and positively stays that cell reference and never changes. An example of a formula with an absolute reference might be =B22*$B$24. The reference to cell B24 will not change when copied.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint