Switch between relative, absolute, and mixed references
- Select the cell that contains the formula.
- In the formula bar
, select the reference you want to change. - Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right.
Formula being copied
| Reference (Description) | Changes to |
|---|---|
| $A$1 (absolute column and absolute row) | $A$1 |
| A$1 (relative column and absolute row) | C$1 |
| $A1 (absolute column and relative row) | $A3 |
| A1 (relative column and relative row) | C3 |