Use Absolute and Relative References
A reference that you make in a formula to the contents of a worksheet cell is either a relative reference, an absolute reference, or a mixed reference. It is important to understand the difference and know which to use when creating a formula.
A relative reference to a cell takes the form A1. When you copy or fill a formula from the original cell to other cells, a relative reference will change to indicate the cell having the same relationship to the formula cell that A1 did to the original formula cell. For example, if a formula in cell B1 references cell A1 and you copy the formula to cell B5, the formula in cell B5 references cell A5.
An absolute reference takes the form $A$1; the first dollar sign indicates ...
Get Microsoft® Office 2008 for Mac Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
