Thread: I want to prevent a formula from being affected by insert line
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StiDude StiDude is offline
external usenet poster
  
Posts: 1
Default I want to prevent a formula from being affected by insert line
I have a formula which is average A1 to A10
When i insert a line in A1 it modifies the formula
to avegare A2-A12 but I want it NOT to change.

Any suggestions ?

Thanks
Reply With QuoteReply With Quote