Absolute Cell References : Cell Reference « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Cell Reference

Make formula an absolute reference by typing a dollar sign ($) before each part of the reference.

For example, $A$1 always refers to cell A1.

You can add a $ before the column letter and the row number.

Copy and paste formula. 
           The formula is the same, but it uses the new cells in its calculation.

6.3.Cell Reference
	6.3.1.	Cell Reference Examples
	6.3.2.	Reference Operator
	6.3.3.	Relative Cell References
	6.3.4.	Absolute Cell References
	6.3.5.	Mixed Cell References
	6.3.6.	Create an Absolute Reference
	6.3.7.	Change an absolute reference back to a relative reference
	6.3.8.	Create a 3-D Cell Reference
	6.3.9.	Reference all values in a column