Thread: locking formula cell references
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Superchikn
 
Posts: n/a
Default locking formula cell references


I have a cell that references B2 i need the reference to stay at B2 even if
i insert a row at row 2. Currently the reference moves to B3. Is there any
way around this?
Reply With QuoteReply With Quote