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