Microsoft KB Archive/104307

{|
 * width="100%"|

XL5: Multiple Sheet Insert Fails

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0
 * Microsoft Excel for the Macintosh, version 5.0

-

SUMMARY
In Microsoft Excel 5.0, you can insert multiple worksheets in a workbook by selecting the number of sheets you want to insert and then choosing Worksheet from the Insert menu or pressing SHIFT+F11. To select multiple sheets, hold down the CTRL or SHIFT key and click the sheet tabs.

Note that you can only insert multiple worksheets; chart sheets, dialog sheets, Visual Basic modules, and Microsoft Excel 4.0 macro sheets must be inserted one at a time.

If you have a sheet AutoTemplate (SHEET.XLT) in your startup directory (XLSTART), only one sheet will be inserted when you select multiple sheet tabs and try to insert your sheets.