XL5: Multiple Sheet Insert Fails

• 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