Exceljet

Quick, clean, and to the point

Absolute reference

Example of Absolute Reference in Excel

An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. Unlike a relative reference, an absolute reference refers to an actual fixed location on a worksheet.

To create an absolute reference in Excel, add a dollar sign before the row and column. For example, an absolute reference to A1 looks like this:

=$A$1

An absolute reference for the range A1:A10 looks like this:

=$A$1:$A$10

Example

In the example shown, the formula in D5 will change like this when copied down column D:

=C5*$C$2
=C6*$C$2
=C7*$C$2
=C8*$C$2
=C9*$C$2

Note that the absolute reference to C2, which hold the hourly rate does not change, while the reference to hours in C5 changes with each new row.

Toggle between absolute and relative addresses

When entering formulas, you can use a keyboard shortcut to toggle through relative and absolute reference options, without typing dollar signs ($) manually.