## 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.