Office 2010 Made Simple

Inserting, Renaming, Deleting, and Rearranging Worksheets

When you create a workbook, Excel puts three worksheets in it by default. You can add extra worksheets as needed, or delete any of these default worksheets you don't need. You can also give the worksheets custom names and rearrange their order.

TIP: To change the number of worksheets that Excel includes in a blank workbook, click the File tab to open Backstage, and then click Options. In the Excel Options dialog box, change the number in the Include this many sheets box to the number of worksheets you want, and then click the OK button.

Inserting a Worksheet

The quick way to insert a worksheet is to activate the worksheet after which you want to insert the new worksheet, and then press ...