Microsoft Office Tutorials and References
In Depth Information
TIP When you select the Create A Copy check box, Excel leaves the copied worksheet in
its original workbook, whereas clearing the check box causes Excel to delete the worksheet
from its original workbook.
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 location you want 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 shortcut 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
To differentiate a worksheet from others, or to visually indicate groups or categories of
worksheets in a multiple-worksheet workbook, you can 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 about 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.
SET UP You need the ExceptionTracking workbook located in the Chapter01 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
On the tab bar, click the New Sheet button to create a new worksheet.
Right-click the new worksheet’s sheet tab, and then click Rename to highlight the
new worksheet’s name.
Enter 2013 , and then press Enter .
On the tab bar, double-click the Sheet1 sheet tab to highlight the worksheet’s name.