View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fruitchunk fruitchunk is offline
external usenet poster
 
Posts: 35
Default How to stop to adjust references automatically

I would like to know how to stop excel from adjusting references
automatically when inserting a new row.

Example:
A1=SUM(A4:A8)

If I insert a new row on A4 the formula on A1 will now be =SUM(A5:A9)
How can I stop it from adjusting automatically,
I want A1 should always be =SUM(A4:A8) no matter if I insert a new row.

Please help, Thanks.