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

## REFERENCES

"User's Guide," version 5.0, Chapters 7 and 36
Microsoft Excel Help, "Overview of Managing Workbook Sheets"

Additional query words: 5.00

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :

Last Reviewed: April 7, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use.