The spreadsheet on the right shows the result of cell A1 being copied to cells A1-C3. This means that a simple cell reference, used within an Excel cell, will be adjusted when copied to other cells.įor example, in the spreadsheet below, cell A1 contains a reference to cell E1. These two reference types are discussed in detail below.īy default, Excel cell references are relative references. These are Relative References (which change when they are moved to different locations) and Absolute References (which remain constant when moved to different locations). There are actually two different types of Excel cell reference, which behave differently when moved into different spreadsheet cells.
If you are using Excel cell references within your formulas, it is important to understand how these can change when they are copied or moved into different cells of a worksheet.
0 kommentar(er)
