Tuesday, April 26, 2011

Relative Cell References


In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells.Cell references are used in formulas, functions, charts , and other Excel commands.By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.


No comments:

Post a Comment