Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a number of worksheets with the same data. I would like to be able to
add a line to the "template worksheet" and have the same line added to all of the other worksheets. Is this possible. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Group all your worksheets together (right-click on a sheet tab and
choose Select All Sheets), then what you do on one (eg inserting a row) will happen on all the sheets. Don't forget to ungroup the sheets afterwards (right-click a sheet tab and choose Ungroup sheets). Hope this helps. Pete On Aug 27, 9:21*pm, Gordon wrote: I have a number of worksheets with the same data. *I would like to be able to add a line to the "template worksheet" and have the same line added to all of the other worksheets. *Is this possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to extract 20 000 lines out of 200 000 lines automatically? | Excel Discussion (Misc queries) | |||
adding lines to a list | Excel Discussion (Misc queries) | |||
Function for adding lines | Excel Worksheet Functions | |||
Adding lines of best fit | Charts and Charting in Excel | |||
Automatically adding Vertical lines after certain points in line graph | Charts and Charting in Excel |