Table of Contents### Task 17 How to Use Absolute and Relative Cell Addresses

Entire Site

When you copy a formula to a new location, the formula is automatically adjusted using relative cell addresses. For example, if you copy the formula `=C2+C3` from cell C4 to cell D4, the formula is changed to `=D2+D3`. The addresses are adjusted by one column because you copied the formula one column over. If you don't want a cell address to change (which is true when the address points to a value that the formula is required to use), use absolute cell addresses. To make an address absolute, precede it with a dollar sign (`$`), as in `=$C$2+C3`. If you copy this formula from cell C4 to cell D4, the formula changes to =$C$2+D3. The absolute address, `$C$2`, does not change.

Enter an Absolute Formula

Now we'll enter a formula that uses absolute addressing:

`=G7-$C$3`. The absolute address`$C$3`points to the sales goal value that all the formulas, regardless of which row they are in, must use. To enter the formula, type the first part of the formula (`=G7-`), click cell C3, and then press F4. Pressing F4 makes the cell address to the left of the cursor absolute.