Absolute Referencing
| When you want to keep a cell reference pointing to the same cell even when you are copying the formulas into other cells you will need to 'fix' the cell. | |
|
To do this click in the appropriate cell reference withing your formula and press F4.
This will add dollar signs around the cell reference, eg. $A$1. |
 |
|
This is called Absolute Cell Referencing.
Copy the formula across or down the cells as normal and the cell reference will stay static. |
 |
