Excel 2019 Bible

Chapter 3: Performing Basic Worksheet Operations

3

FIGURE 3.2

Use the tab scrolling controls to activate a different worksheet or to see additional worksheet

tabs.

Tab scrolling controls

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 double-clicking it in 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 four ways to add a new worksheet to a workbook:

■ Click the New Sheet control, which is the plus sign icon located to the right of the

last visible sheet tab. A new sheet is added after the active sheet.

■ Press Shift+F11. A new sheet is added before the active sheet.

■ (^) From the Ribbon, choose Home ➪ Cells ➪ Insert ➪ Insert Sheet. 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.
If the worksheet is not empty, Excel asks you to confirm that you want to delete the sheet
(see Figure 3.3).