
256
11
22
●
Excel switches the address to an
absolute cell reference.
4 Repeat Steps 2 and 3 to switch
any other cell addresses that you
require in the absolute reference
format.
5 Press .
1 Double-click the cell that contains
the formula you want to edit.
2 Select the cell reference you want
to change.
3 Press + .
Switch Between Relative and Absolute Cell References
You can make some formulas easier to copy by
switching to absolute cell references. When you
use a regular cell address — called a relative cell
reference — such as A1 in a formula, Excel
adjusts that reference when you copy the
formula to another location. To prevent that
reference from ...