Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Defined Names > Absolute/Relative
Deze pagina in het Nederlands

Range Names In Excel

Absolute And Relative Addressing

When you define a name, Excel defaults to using absolute cell references: Sheet1!$A$1. The dollar signs indicate that the address should be interpreted absolutely, independent of the cell that calls the name.

You can also use relative references however, giving you interesting possibilities.

If for example you select cell C3 on Sheet2 and define a name as =Sheet2!A1 (See Fig. 7), Then this name will point to a cell two columns to the left and two rows up from the cell the name is used in.

Fig. 7, Defining a relative name

So the formula =Relative in cell C14 on Sheet2 will point to cell A12 (see Fig. 8).

Fig. 8: Example of a relative reference in a name