Inserting Worksheets

When you create a new workbook, it contains three worksheets. But what do you do if you need four or five worksheets in your workbook? A workbook can contain as many worksheets as you need. Excel makes inserting a worksheet easy to do.



To add a worksheet:

  1. Right-click on a Sheet tab.
  2. Select Insert... from the shortcut menu.
  3. To insert a simple worksheet: click the Worksheet icon in the dialog box.
  4. To insert a formatted worksheet: click the Spreadsheet Solutions tab, and click any of the template icons.
  5. Click OK.


You can insert more than one worksheet at once. First, select the number of worksheets you want to add. Next, right-click and select Insert... Click the Worksheet icon, and click OK.

You can also select Worksheet on the Insert menu to insert a plain worksheet.