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

Get Office 2010 Made Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.