| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
INSERT ROWS WITHOUT SCREWING-UP FORMULAS!
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! |
|
#2
|
|||
|
|||
|
Insert a Row using a Macro to maintain formula
http://www.mvps.org/dmcritchie/excel/insrtrow.htm Please use your own name, and avoid excessive CAPS. http://www.cpearson.com/excel/newposte.htm http://www.mvps.org/dmcritchie/excel...tm#useyourname -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BILL GATES - I WANNA WORD WITH YOU!" <BILL GATES - I WANNA WORD WITH wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Auto Insert of Rows | Excel Worksheet Functions | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Hybrid Mode
