Monday, 10 September 2012

Absolute Cell References

Make formula an absolute reference by typing a 
dollar sign ($) before each part of the reference.
If you don't want a cell reference to change when you copy a formula, make it an absolute reference by typing a dollar sign ($) before each part of the reference.
For example, $A$1 always refers to cell A1.
For example, $A$1 always refers to cell A1.
You can add a $ before the column letter and 
the row number.
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.
The formula is the same, but it uses the new cells in its calculation.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)