Microsoft Office Tutorials and References
In Depth Information
Adding a new worksheet to your workbook
When you right-click any of the tab scrolling controls, Excel displays a list of all sheets in the workbook. You can
quickly activate a sheet by selecting it from the list.
Adding a new worksheet to your workbook
Worksheets can be an excellent organizational tool. Instead of placing everything on a
single worksheet, you can use additional worksheets in a workbook to separate various
workbook elements logically. For example, if you have several products whose sales you
track individually, you may want to assign each product to its own worksheet and then use
another worksheet to consolidate your results.
Here are three ways to add a new worksheet to a workbook:
Click the New Sheet button, which is the plus sign icon located to the right of
the last sheet tab. A new sheet is added after the active sheet.
Press Shift+F11. A new sheet is added before the active sheet.
Right-click a sheet tab, choose Insert from the shortcut menu, and select the
General tab of the Insert dialog box that appears. Then select the Worksheet icon
and click OK. A new sheet is added before the active sheet.
Deleting a worksheet you no longer need
If you no longer need a worksheet, or if you want to get rid of an empty worksheet in a
workbook, you can delete it in either of two ways:
Right-click its sheet tab and choose Delete from the shortcut menu.
Activate the unwanted worksheet and choose Home
Cells
Delete
Delete
Sheet.
14
If the worksheet contains any data, Excel asks you to confi rm that you want to delete the
sheet (see Figure 14.3). If you’ve never used the worksheet, Excel deletes it immediately
without asking for confi rmation.
FIGURE 14.3
Excel’s gentle warning that you might be losing some data
Search JabSto ::




Custom Search