| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting rows in linked worksheets
i have worksheet "1" as my master worksheet with other worksheets linking to
its data. When i instert a new row in worksheet "1" i dont see the new row in the other worksheets that are linked to it....how can i accomplish inserting new rows in worksheet "1" so that all other worksheets get the same new row inserted??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting rows in linked worksheets
If the sheets are all in the same workbook, select sheet 1, select the
line where you want to insert a line, select all the sheets and perform the insert. Excel will insert a line at the same point in all selected sheets. If you right click a sheet tab you can select "select all sheets". Hans |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
| Link Rows Between Worksheets | Excel Discussion (Misc queries) | |||
| Inserting rows in source workbook | Excel Discussion (Misc queries) | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
Linear Mode
