Introduction
Absolute references keep a cell address fixed when copying formulas. This helps when you want to use the same cell in many formulas without changing it.
When you want to multiply many numbers by the same tax rate stored in one cell.
When you need to add a fixed fee from one cell to many prices in a list.
When copying a formula that uses a constant value from a specific cell.
When creating a budget that refers to a fixed exchange rate in one cell.
When you want to lock a reference to a header or total cell while copying formulas.