|
For some of you, the three worksheets automatically put into each new workbook that you start are as many as you would ever need (or want) to use. For others of you, a measly three worksheets might seldom, if ever, be sufficient for the workbooks you create. (For example, say your company operates in ten locations, or you routinely create budgets for 20 different departments or track expenses for 40 account representatives.)
Excel makes it easy to insert additional worksheets in a workbook or remove those that you don't need. To insert a new worksheet in the workbook, follow these steps:
1. Select the tab of the sheet where you want Excel to insert the new worksheet.
2. Choose Insert-->Worksheet or choose Insert on the sheet tab's shortcut menu.
If you choose the Insert-->Worksheet command, Excel inserts a new worksheet and gives its tab the next available number (like Sheet4). If you choose the Insert command on the sheet tab's shortcut menu, Excel opens the Insert dialog box where you can specify the type of sheet to insert (such as Worksheet, Chart, MS Excel 4.0 Macro, or MS Excel 5.0), and you need to proceed to Step 3.
3. Make sure that the Worksheet icon on the General tab of the Insert dialog box is selected and then click OK or press Enter.
To insert a bunch of new worksheets in a row in the workbook, select a group with the same number of tabs as the number of new worksheets you want to add, starting with the tab where the new worksheets are to be inserted. Next, choose Insert-->Worksheet or choose Insert on the tab's shortcut menu. Finally, click OK in the Insert dialog box or press Enter.
To delete a worksheet from the workbook, follow these steps:
1. Click the tab of the worksheet you want to delete.
2. Choose EditDelete Sheet or choose Delete on the tab's shortcut menu.
Excel then displays a scary message in an alert box about how you're going to permanently delete the selected sheets.
3. Go ahead and click the OK button or press Enter if you're really sure that you want to zap the entire sheet.
 | Just keep in mind that this is one of those situations where Undo is powerless to put things right by restoring the deleted sheet to the workbook. |
To delete a bunch of worksheets from the workbook, select all the worksheets you want to delete and choose
Edit-->Delete Sheet or choose Delete on the tab's shortcut menu. Then, if you're sure that none of the worksheets will be missed, click OK or press Enter when the alert dialog box appears.
 | If you find that you constantly have to monkey around with the number of worksheets in a workbook, either by adding new worksheets or deleting a bunch, you may want to think about changing the default number of worksheets in a workbook. To change the magic number of three sheets to a more realistic number for your needs, choose
Tools-->Options to open the Options dialog box, select the General tab, and enter a new number between 1 and 255 in the Sheets in new workbook text box or select a new number with the spinner buttons before you click OK. |
| 
