Cell references in Excel are like addresses that point to specific cells. Three types of Excel cell references are relative, absolute, and mixed, each with unique functions.

Pages Absolute and relative cell references Each cell in a worksheet has a unique reference that describes its position – for example A1.

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

When you type the cell reference in your formula, press F4. For example, in the formula =A6*B7, press F4 right after you type the 6 and the absolute reference $ will appear.

1. Use Relative cell references Always use Relative cell references/addresses (the default is Absolute references) unless your macro is for one specific application in one spreadsheet.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.