XL5: Multiple Sheet Insert Fails

ID: Q104307


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 :


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