Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert rows into multiple sheets in a workbook?
I have an excel workbook that is 145 sheets large. Most of the sheets have
cells with reference points to the first sheet. I need to add a row to EACH sheet in the same location. Is it possible to add a row to each sheet with one basic command or do I have to do it on EACH individual sheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert rows into multiple sheets in a workbook?
You can group all your sheets together, so that whatever you do to one
sheet is done to them all - you must remember to ungroup them at the end. Assuming all your sheets are contiguous, then click on the first sheet, hold down SHIFT and click on the last sheet. (If they are not contiguous you will have to hold down CTRL instead of SHIFT and click on each one). Then you can highlight the row in the visible sheet and Insert | Row - this will be inserted at that position in every sheet which is part of the group. To ungroup the sheets right-click on one of the sheet tabs. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert rows into multiple sheets in a workbook?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert same picture in multiple sheets and only change once | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
How can I create multiple rows of worksheet tabs in a workbook? | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) |