Microsoft Office Tutorials and References
In Depth Information
Tip Selecting the Create A Copy check box leaves the copied worksheet in its original
workbook, whereas clearing the check box causes Excel to delete the worksheet from its
After the worksheet is in the target workbook, you can change the worksheets’ order to
make the data easier to locate within the workbook. To change a worksheet’s location in
the workbook, you drag its sheet tab to the desired location on the tab bar. If you want
to remove a worksheet from the tab bar without deleting the worksheet, you can do
so by right-clicking the worksheet’s tab on the tab bar and clicking Hide on the context
menu. When you want Excel to redisplay the worksheet, right-click any visible sheet tab
and then click Unhide. In the Unhide dialog box, click the name of the sheet you want to
display, and click OK.
To differentiate a worksheet from others, or to visually indicate groups or categories of
worksheets in a multiple-worksheet workbook, you can easily change the color of a worksheet
tab. To do so, right-click the tab, point to Tab Color, and then click the color you want.
Tip If you copy a worksheet to another workbook, and the destination workbook has the
same Office Theme applied as the active workbook, the worksheet retains its tab color. If
the destination workbook has another theme applied, the worksheet’s tab color changes
to reflect that theme. For more information on Office themes, see Chapter 4, “Changing
If you determine that you no longer need a particular worksheet, such as one you created
to store some figures temporarily, you can delete the worksheet quickly. To do so,
rightclick its sheet tab, and then click Delete.
In this exercise, you’ll insert and rename a worksheet, change a worksheet’s position in a
workbook, hide and unhide a worksheet, copy a worksheet to another workbook, change
a worksheet’s tab color, and delete a worksheet.