When you create a new workbook, it contains three worksheets. You can easily add additional worksheets to a workbook.
Start with More Sheets You can change the default number of worksheets Excel places in a new workbook by opening the Tools menu, selecting Options , clicking the General tab, and then changing the number in the Sheets in New Workbook option. Click OK to save your changes. The maximum value for the number of worksheets in a workbook is determined by the amount of memory on your computer. If you use more than 20 worksheets in a workbook and the worksheets are full of data, you might find that Excel's overall performance starts to slow down.
Follow these steps to add a worksheet to a workbook:
Select the worksheet that you want to be to the right of the inserted worksheet. For example, if you select the August sheet shown in Figure 13.1, the new sheet will be inserted to the left of August.
Figure 13.1. Excel inserts the new worksheet to the left of the active worksheet.
Select the Insert menu.
Select Worksheet . Excel inserts the new worksheet to the right of the previously selected worksheet.
Use the Shortcut Menu A faster way to work with worksheets is to right-click the worksheet's tab. This brings up a shortcut menu that enables you to insert, delete, rename, move, copy, or select all worksheets.