Part I: Getting Started with Excel
FIGURE 3.4
Use the Move or Copy dialog box to move or copy worksheets in the same or another work-
book.
You can move or copy multiple sheets simultaneously. First, select the sheets by clicking their sheet tabs while hold-
ing down the Ctrl key. Then you can move or copy the set of sheets by using the preceding methods.
If you move or copy a worksheet to a workbook that already has a sheet with the same
name, Excel changes the name to make it unique. For example, Sheet1 becomes Sheet1 (2).
You probably want to rename the copied sheet to give it a more meaningful name. (See
“Changing the Name of a Worksheet” earlier in this chapter.)
When you move or copy a worksheet to a different workbook, any defined names and custom formats are also copied
to the new workbook.
Hiding and unhiding a worksheet
In some situations, you may want to hide one or more worksheets. Hiding a sheet may be
useful if you don’t want others to see it or if you just want to get it out of the way. When a
sheet is hidden, its sheet tab is also hidden. You can’t hide all of the sheets in a workbook;
at least one sheet must remain visible.
To hide a worksheet, choose Home ➪ Cells ➪ Format ➪ Hide & Unhide ➪ Hide Sheet, or
right-click its sheet tab and choose Hide. The active worksheet (or selected worksheets) will
be hidden from view.
To unhide a hidden worksheet, choose Home ➪ Cells ➪ Format ➪ Hide & Unhide ➪ Unhide
Sheet, or right-click any sheet tab and choose Unhide. Excel opens the Unhide dialog box,
