Auto Fill with some references locked
Hi Andreas,
In Excel 2003, when I want an absolute cell reference, (in this example
A2), I list the cell as this: $A$2
Placing the dollar signs in front of the row and column should keep
that cell constant, no matter where it's copied as a formula in other
cells.
Good luck with this!
Karen
|