View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Karen
 
Posts: n/a
Default 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