Friday, December 11, 2009

What is an absolute reference in Microsoft Excel 2007 spreadsheet?

Dollar signs specify an absolute reference to a cell’s column and/or row.

Examples: =A1, =$A1, =$A$1

When copying a formula with an absolute reference, the $'d column or row will not change.

Example:

=A11 moved down will be A12
=A$11 moved down will be A11