An absolute reference in Excel is a cell reference that stays fixed when you copy or fill a formula to other cells, instead of shifting like a normal (relative) reference.

Simple definition (Quick Scoop)

  • In a normal formula like =A1, if you copy it down one row, it becomes =A2. That’s a relative reference.
  • In an absolute reference like =$A$1, if you copy it anywhere, it still points to A1.
  • You “lock” a cell by adding dollar signs ($) before the column and row: =$A$1.

Think of $ as a pin that keeps the reference from moving.

How absolute references look

There are three common patterns:

  • Full absolute: =$A$1
    • Column A and row 1 are both locked.
  • Column absolute only (mixed): =$A1
    • Column A is locked, row changes when copied.
  • Row absolute only (mixed): =A$1
    • Row 1 is locked, column changes when copied.

All of these use the $ symbol to control what moves and what doesn’t.

Why use an absolute reference?

You use an absolute reference when one part of your formula must always refer to the same cell , such as:

  • A tax rate stored in a single cell
  • A fixed commission percentage
  • A currency conversion rate
  • A constant bonus value applied to many employees

Example:
If cell B1 has a tax rate and A2 has a price, you might write:

  • =A2*$B$1

When you copy this down, A2 becomes A3, A4, etc., but $B$1 stays locked on the tax rate.

How to create an absolute reference quickly

You can create or toggle absolute references in two ways:

  1. Manually add dollar signs
    • Type them directly: A1 → =$A$1.
  2. Use the F4 key shortcut (Windows)
    • Click inside the cell reference in the formula bar (e.g., A1).
    • Press F4 to cycle through:
      • A1 → =$A$1 → =A$1 → =$A1 → back to A1.

This is the go‑to move for Excel users when they want to “lock” a reference without retyping.

Quick story-style example

Imagine you’re building a sheet in 2026 to calculate product prices with a global VAT stored in cell B1:

  • Row 2 has a product price in A2.
  • You write =A2*$B$1 in C2 to calculate “Price with VAT.”
  • You drag the formula down for 1,000 products.

Because $B$1 is absolute, every row uses the same VAT in B1, while only the product price cell changes. Without the $, you’d eventually reference empty cells and get wrong results.

SEO-style extras

  • Focus phrase: what is absolute reference in excel
  • Meta-style summary:
    An absolute reference in Excel is a locked cell reference created with $ (like =$A$1) so that, when formulas are copied, that reference does not change.

TL;DR:
An absolute reference in Excel is a cell reference with $ (e.g., =$A$1) that stays fixed when copied, used whenever one value (like a rate or constant) must never move in your formulas.

Information gathered from public forums or data available on the internet and portrayed here.