Thread: I want to copy a formula down several rows and lock a cell ref.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default I want to copy a formula down several rows and lock a cell ref.
Use $ signs eg = $A$1. See help on absolute versus relative references.

Hope this helps
Rowan

abcdbaker wrote:
How do I lock a cell reference in the formula that I'm dragging to other rows.
Reply With QuoteReply With Quote