INSERT ROWS WITHOUT SCREWING-UP FORMULAS!

G

Guest

HELP! I need to insert rows in a worksheet that has a formula on it. When I
use the Insert row command, my formulas get disrupted and all the rows after
the inserted row do not 'add-up'. How do I ask 'excel' to insert rows and
calculate my new row onward to integrate them within the formula?

PS. I am a TECHNOPHOBE! EASY TO FOLLOW JARGON WOULD BE APPRECIATED.

Cheers!

FRUSTRATED!
 

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

Formulas Affected by Insert Row 7
Insert Copied Rows or Drag/Drop Formulas While Protected 2
insert muliple rows, every 4th row 7
insert blank row and formulas 1
Can array formulas work if rows are inserted? 1
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Insert a rows automatically 3
insert rows--->protected sheet 1

Top