Home |
Search |
Today's Posts |
#1
|
|||
|
|||
inserting 12 worksheets at once
I am using Excel 2003. I would like to insert 12 worksheet at the same time.
Is there a way to make this happen? Thanks for the help! |
#2
|
|||
|
|||
inserting 12 worksheets at once
If your worksheet has 12 or more worksheets in it then you can add 12
additional ones by activating 12 of them (select one tab, hold down the shift key and select the 12th sheet, they'll be grouped, so don't change anything while they're grouped) and then selecting Insert/Worksheet. If you don't have 12 sheets in the file, then you'll have to do it for as many sheets as are in the file. This can also be done easily with VBA code if you want to take that route, but I haven't written any code for this instance. Jeff "SheriTingle" wrote in message ... I am using Excel 2003. I would like to insert 12 worksheet at the same time. Is there a way to make this happen? Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Define list of worksheets | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |