View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excel rookie
 
Posts: n/a
Default How do I keep one cell constant in a formula even when copying

I'm doing a spreadsheet that refers back to a specific cell. My problem is
that when I copy the original formula it moves away from that specific cell.
I need to create a formula that will keep a specific cell in place and allow
the rest of the formula change as I copy it elsewhere.