A relative addresses will change when copied to other location in a worksheet because it describes the “offset” to another cell, rather than a fixed address. To help understand what this means, consider the phrase “the house next door to the right”. You can only understand the location of this house if you understand the starting point, because the location is described in relative terms. By default, all references in Excel formulas are relative. You can convert a relative reference to absolute reference with by using dollar sign ($) characters.


In the example shown, the formula in E4 contains two relative references that will change as follows when copied down column E: Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.