How do I keep a formula from changing if a row is added or deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to skip
the new row or receive an #REF! error when a row is deleted. Regardless of
what happens in the worksheet I want the formulas to remain the same.
 
You must log in or register to reply here.

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 do I keep a formula from changing if a row is added or delete. 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Deleting blank rows with formulas in them 7
Excel Help to copy information from one row at a time to another sheet 1
Deleting rows with formulas is very slow 2
Way to keep formulas unchanged when deleting rows? 9
how do I keep rows' formats when copying a formula? 2
stop excel automatically changing formulas 3

Back
Top