"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.