If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding rows to several worksheets
I want to insert a row in worksheet #1 and want it automatically to happen in
all the other sub-worksheets (2 - 10) in this workbook as well. Any idea? Regards |
#2
|
|||
|
|||
Hi Stefanie,
Group the sheets, either add sheets to the the selected sheets by holding CTRL and selecting another add sheets by hold ctrl+shift to add additional sheets through the one you click on right click of the sheet tab and choose Group all shees When you are finished you MUST ungroup your sheets as any further changes would also affect all of your sheets and destroy your workbook very fast. Right click on the sheet tab and choose Ungroup Sheets If you want to copy the formulas down from the previous row with a macro on all of the sheets you can see the insert rows and maintain formulas macro on http://www.mvps.org/dmcritchie/excel/insrtrows.htm which was designed for a single sheet but was modified to handle grouped sheets as well. Same thing as before UNGROUP sheets when finished. 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 "Stefanie" wrote ... I want to insert a row in worksheet #1 and want it automatically to happen in all the other sub-worksheets (2 - 10) in this workbook as well. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding rows in shared files | ir | General Discussion | 1 | September 22nd, 2004 12:15 AM |
Adding Rows to Worksheet | C Jacobs | Worksheet Functions | 1 | October 1st, 2003 05:08 PM |