Absolute references ($A$1) in Excel - Step-by-Step Guide

Introduction

Absolute references keep a cell reference fixed when copying formulas. This helps when you want to use the same cell in many calculations without changing it.

When you want to multiply many numbers by a single fixed value like a tax rate.

When you need to refer to a constant cell like a discount percentage in multiple formulas.

When copying a formula across rows or columns but want one part of the formula to stay the same.

When creating a budget and you want to always refer to the total amount in one cell.

When using a fixed cell for a lookup table or parameter in calculations.

Steps

Step 1: Click

- cell where you want to enter the formula

The cell is selected and ready for input

Step 2: Type

- formula bar

Formula starts appearing in the cell and formula bar

💡 Start with = to begin a formula

Step 3: Type

- formula bar

Enter a cell reference with dollar signs, for example $A$1

💡 Dollar signs before column letter and row number lock the reference

Step 4: Complete

- formula bar

Press Enter to finish the formula and show the result

Step 5: Copy

- the cell with the formula

Formula is copied to other cells

💡 Use Ctrl+C or drag the fill handle

Step 6: Paste or drag

- cells where you want the formula copied

Formula adjusts except the absolute reference stays the same

Before vs After

Before

Formula in B2 is =A1*B1 and copying it to C2 changes it to =B1*C1

After

Formula in B2 is =$A$1*B1 and copying it to C2 keeps $A$1 fixed, so it becomes =$A$1*C1

Settings Reference

Absolute Reference

📍 Formula bar when typing a formula

Locks the column and row so the reference does not change when copying formulas

Default: A1 (relative)

Common Mistakes

Not using dollar signs when copying formulas

The cell references change and give wrong results

Use $ before column and row to fix the reference like $A$1

Using only one dollar sign incorrectly

Only part of the reference is fixed, which may not be what you want

Use $ before both column and row to fully fix the cell, or understand mixed references

Summary

Absolute references keep a cell fixed when copying formulas.

Use $ before column and row like $A$1 to lock the reference.

This helps when you want to use the same cell in many formulas without changing it.