Microsoft Office Tutorials and References
In Depth Information
Creating an Absolute Reference in a Formula
Note
Understanding Absolute References It’s called an absolute reference
because when you copy it, it absolutely stays that cell reference and
never changes. An example of a formula with an absolute reference
might be =B21*$B$23. The reference to cell B23 will not change when
copied.
Press Enter . The result of the calculation displays in the cell.
Copy the formula to the adjacent cells using either the Fill or Copy and
Paste method.
Search JabSto ::




Custom Search