| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 workbook, 4 worksheets, want to add rows in same place in all WS
I have a workbook with 4 worksheets. I want to add and delete rows in the
same place within the 4 worksheets when I add to a particular worksheet. Similarly, I want to delete rows in the same place in all 4 worksheets when I delete in a particular worksheet. Know how? I'm interested in learning how. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
1 workbook, 4 worksheets, want to add rows in same place in all WS
Group the sheets (either by shift-click on first & last tab, or
control-click on each one). Then an edit on one of the grouped sheets will apply to all. Remember to ungroup afterwards. -- David Biddulph "RogerDO" wrote in message ... I have a workbook with 4 worksheets. I want to add and delete rows in the same place within the 4 worksheets when I add to a particular worksheet. Similarly, I want to delete rows in the same place in all 4 worksheets when I delete in a particular worksheet. Know how? I'm interested in learning how. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
| One workbook to another . . . | Excel Discussion (Misc queries) | |||
| Add or Delete Rows in Protected worksheets | Excel Discussion (Misc queries) | |||
| Some worksheets not viewable within a workbook on a particular PC | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
Linear Mode
