View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom Hardy
 
Posts: n/a
Default Copying formulas from cell to cell to cell to.......

Probably simple, but I can't find answer. I want to copy a formula from 1
cell to a lot of other cells. When you do this, any cell addresses in the
formula change based on where you copied the formula to. How can I make 1 of
the cell addresses in the formula stay the same no matter where I copy it? It
would be a "constant" in my formula and only changed from a "data entry
sheet".

Thanks, Tom

Example: In A1 I might have: =(C1*D1)+742
If I move this to A2, it will become: +(C2*D2)+742

I want D1 to remain the same. ??????