Excel 2010 Absolute Reference
By default, cell references in Excel are relative. For example, if you have the following formula in cell C1:
and you copy the formula to cell C2, you will get =A2+B2. This is because the cell references are relative. The contents of cell C1 are calculated to be the sum of the the cell that is 2 cells to the left and the cell that is 1 cell to the left. This easily transposes to cell C2.
To demonstrate, I copied cell C1 to cell C2 and got this:
You can see in the formula bar that the original formula of =A1+B2 has been transformed to =A2+B2 when copied to cell C2.
But what if we want to always use A1+B1 in all cells we copy that formula to? This is where absolute cell references come in.
How To Construct An Absolute Cell Reference
In Excel, we create an absolute cell reference by using a “$” before each letter and number. The formula for C1 then becomes
=$A$1+$B$2
Copying that formula to C2 retains those absolute references and we find the that C2 also uses =$A$1+$B$2.
You can also mix ansolute with relative references like this: A$1. Here the row is fixed at one, but the column remains relative.