Excel 2019 Bible

Part I: Getting Started with Excel

FIGURE 3.3

Excel’s warning that you might be losing some data

You can delete multiple sheets with a single command by selecting the sheets that you want to delete. To select mul-

tiple sheets, press Ctrl while you click the sheet tabs that you want to delete. To select a group of contiguous sheets,

click the first sheet tab, press Shift, and then click the last sheet tab (Excel displays the selected sheet names bold

and underlined). Then use either method to delete the selected sheets.

When you delete a worksheet, it’s gone for good. Deleting a worksheet is one of the few operations in Excel that can’t

be undone.

Changing the name of a worksheet

The default names that Excel uses for worksheets—Sheet1, Sheet2, and so on—are generic

and nondescriptive. To make it easier to locate data in a multisheet workbook, you’ll want

to make the sheet names more descriptive.

These are three ways to change a sheet’s name:

■ From the Ribbon, choose Home ➪ Cells ➪ Format ➪ Rename Sheet.

■ (^) Double-click the sheet tab.
■ Right-click the sheet tab and choose Rename Sheet.
Excel highlights the name on the sheet tab so that you can edit the name or replace it with
a new name. While editing a sheet name, all of the normal text selection techniques work,
such as Home, End, arrow keys, and Shift+arrow keys. Press Enter when you’re finished
editing and the focus will be back on the active cell.
Sheet names can contain as many as 31 characters, and spaces are allowed. However, you
can’t use the following characters in sheet names:
: Colon
/ Slash
\ Backslash
[ ] Square brackets