Thread: How do I fix cell refs when adding rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave L
 
Posts: n/a
Default How do I fix cell refs when adding rows
Is there any way for me to insert a row without changing a cell ref in a
formula eg =sum(a1:a5) instead of changing to A2:A6 I want A1:A6 ie the range
increases in line with the added row.

TIA
Dave
Reply With QuoteReply With Quote