You might have wondered what the dollar sign means in some Excel formulae. Excel has two fundamentally different methods to make reference to cells in a formula. For efficient work with Excel, it is extremely important to know the difference between Relative and Absolute Addressing, so that the results will not be calculated incorrectly. We show you in this special topic, what the difference is between both forms of Addressing and how to use them skillfully.

Published on: 17.01.2023

Excel 2016

Absolute References  
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas. (6 Min.)



Excel 2013

Absolute References  
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas. (6 Min.)



Excel 2010

Absolute References  
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas. (6 Min.)



Excel 2007

Absolute References  
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas. (6 Min.)