- $A$1: Cell does not move at all when pasting.
- $A1: Cell does not move when pasting horizontally
- A$1: Cell does not move when pasting vertically

Naming cells

- Allow you to refer to a specific cell with a name (e.g. INTEREST_RATE)
- Will appear in the autocomplete, just press TAB to complete
- Make your formulas much more readable
- Need to be deleted if you're moving the location of the named value