Using the New Sheet Icon to Add Worksheets
The final new control in the Excel 2007 user interface is the Insert Worksheet icon. This icon appears as a small worksheet tab with a New icon. The tab appears to the right of the last worksheet tab, as shown in Figure 3.16.
Figure 3.16 Add a new worksheet to the end of your workbook by using the New Worksheet icon.
You click the icon to add a new worksheet to the end of the workbook.
Dragging a Worksheet to a New Location
After a worksheet has been added to the end of the workbook, you can drag the sheet to a new location in the middle of the workbook. Follow these steps to move a worksheet to a new location:
- Click on the Worksheet tab.
- Drag the mouse left or right. The mousepointer shows a sheet of paper under the mousepointer.
- Watch for the insertion triangle just above the row of sheet names. In general, the insertion triangle will indicate that the sheet is dropped to the left of the sheet you are hovering above.
- When the insertion triangle is in the correct location, release the mouse button.
The worksheet will be moved to the new location.
Inserting a Worksheet in the Middle of a Workbook
Although using the New Worksheet icon and then dragging a worksheet to a new location is easier, you can also insert a worksheet in a particular location. To insert a worksheet to the left of the current worksheet, for example, you choose Home, Cells, Insert, Insert Sheet. The new sheet is added before the current sheet.
Alternatively, you can right-click any sheet and choose Insert. The Insert dialog appears, where you can choose to insert a worksheet or a variety of templates. The new sheet appears to the left of the selected tab.