Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Excel Cell Reference Modes

Overview

Excel has three addressing modes: Relative , Absolute and Mixed .

Absolute addresses will reference the same cell no matter where the reference is moved or copied in a worksheet.  For example, when you copy the formula =$A$3 from B3 to C5, it will still read =$A$3.

A Relative address will reference the same cell in relation to any cell where it is copied.  For example cell B3 is one cell to the right of A3, so when you copy the formula =A3 from B3 to C5, it will now read =B5.

Mixed mode addressing contains one relative coordinate and one absolute coordinate, for example $A3 or A$3.  Mixed mode addressing is extremely useful for quickly generating reports using NL and NF functions.

Published:

Excel Cell Reference Modes

Overview

Excel has three addressing modes: Relative , Absolute and Mixed .

Absolute addresses will reference the same cell no matter where the reference is moved or copied in a worksheet.  For example, when you copy the formula =$A$3 from B3 to C5, it will still read =$A$3.

A Relative address will reference the same cell in relation to any cell where it is copied.  For example cell B3 is one cell to the right of A3, so when you copy the formula =A3 from B3 to C5, it will now read =B5.

Mixed mode addressing contains one relative coordinate and one absolute coordinate, for example $A3 or A$3.  Mixed mode addressing is extremely useful for quickly generating reports using NL and NF functions.

For an optimal Community experience, Please view on Desktop