Absolute Cell Referencing
When you need to perform a formula that requires you to reference the same cell whilst moving down or across. You will need to lock the cell reference by using $ Dollar signs.
To create Absolute Cell Referenced cells you will need to use the $ or press F4
Mac users press Command T
Depending on where the dollar sign is, depends on which part of a cell reference will be locked (remain constant). See the table below for examples.
Column and Row
||When drag across or down both column and row are constant
||When drag across column is constant
||When drag down Row is constant
When deciding on an Absolute you need to think will you be filling down, across or both, down the row reference changes, across the column reference changes.
In the example below I have revealed the formulas for the entire sheet so you can see the pattern of what happens naturally. You’re looking at Cell C8.
The Formula is =B8*B3
Let’s focus on what’s happening to B3 which is the cell that refers to the 12% in cell B3. Notice 3 is changing to 4 then 5, then 6 then 7. If you find yourself changing the 4 to a 3 manually then you have answered your question which part of the cell needs the dollar sign in front of it. It’s the 3