What is Absolute Addressing in Excel?

Absolute Addressing keeps the cell reference the same when calculating formulas. It is used when you want to include a single cell in a formula and use this to calculate many cells in a range of data.

1. It is expressed using the dollar sign: $C$4

2. Create a blank workbook and fill in the following details:

3. We want to calculate the interest on a savings account based on the amount saved

4. To do this, we need to multiply the interest rate in C4 by each of the amounts in Column A

5. Instead of typing out the formula for each amount, we can use Absolute Addressing

4. In cell B4 enter the following formula:

=A4*$C$4

5. Press the Enter key

6. The value should be €18

7. Hover the mouse pointer over the bottom right-hand corner of the active cell

8. Click and drag down the formula to copy it to cells B4:B7

9. The resulting table should look like this: