Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I add the same data to every worksheet in a workbook all .
I want to add rows and test to a workbook. It is a calendar and the added
data is the same for each worksheet. How can I accomplish this without doing each page separately. |
#2
|
|||
|
|||
Right click on the tab for any sheet and choose 'Select All Sheets'
Now, anything you do to one sheet is copied to all the sheets. DANGER WILL ROBINSON - try to remember to ungroup the sheets when you're done (I never do), so that you don't propogate to every sheet changes you want to make just to the current sheet. "Phyllis" wrote in message ... I want to add rows and test to a workbook. It is a calendar and the added data is the same for each worksheet. How can I accomplish this without doing each page separately. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions | |||
Searching and Retrieving data from a Worksheet | Excel Worksheet Functions | |||
How do I pull data from a previous worksheet? | Excel Worksheet Functions | |||
How to move data on worksheet | Excel Discussion (Misc queries) | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |