How to insert a row and not update existing formulas?

B

Bobshaw

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I copy/paste a formula that skips 27 rows? 0
Formula ... Minus Holidays? 1
How to Update SUM formula after inserting rows 2
How To Have A Cell Be Blank If... 2
deleting rows messing up formulas 2
Insert row 1
Fill formula down for cells 74 rows apart 3
adding cells then sorting 1

Top