Inserting new sheets

There are many ways to insert a new sheet. The first step for all of the methods is to select the sheets that the new sheet will be inserted next to. Then any of the following options can be used.

• Click on the Insert menu and select Sheet, or

• Right-click on its tab and select Insert Sheet, or

• Click into an empty space at the end of the line of sheet tabs (see Figure 11).

Each method will open the Insert Sheetdialog (Figure 12). Here you can select whether the new sheet is to go before or after the selected sheet and how many sheets you want to insert.