View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bobshaw Bobshaw is offline
external usenet poster
 
Posts: 2
Default How to insert a row and not update existing formulas?

I have cells containing references to cells in otherworksheets, ie.
=Sheet1!F12. If I enter a row above this it automatically becomes
=Sheet1!F13. How can I prevent this? Please explain in simple terms for a
simple man!