CURRENT FUNCTIONALITY

Add multiple worksheets
Determine the number or worksheets you want to add.

Hold down SHIFT, and then select the same number of existing worksheet tabs
that you want to add in the open workbook.

Example: If you want to add three new worksheets, select three existing
worksheet tabs.

Click Worksheet on the Insert menu.

FUTURE FUNCTIONALITY

Currently if an Excel file has only one worksheet there isn't a way to add
multiple new worksheets except one at a time. Maybe when the user clicks
INSERT WORKSHEET there is another option for ONE or MULTIPLE and if the
user selects MULTIPLE they are prompted to type in the number new worksheets
they want added.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

"Craig" wrote in message
...
CURRENT FUNCTIONALITY

Add multiple worksheets
Determine the number or worksheets you want to add.

Hold down SHIFT, and then select the same number of existing worksheet
tabs
that you want to add in the open workbook.

Example: If you want to add three new worksheets, select three existing
worksheet tabs.

Click Worksheet on the Insert menu.

FUTURE FUNCTIONALITY

Currently if an Excel file has only one worksheet there isn't a way to add
multiple new worksheets except one at a time. Maybe when the user clicks
INSERT WORKSHEET there is another option for ONE or MULTIPLE and if the
user selects MULTIPLE they are prompted to type in the number new
worksheets
they want added.

Add one sheet, then F4 as many more as you want.