Microsoft Office Tutorials and References
In Depth Information
Don’t Short-Sheet Me!
the color palette. After you select a new color for a sheet tab, the name of the
active sheet tab appears underlined in the color you just selected. When you
make another sheet tab active, the entire tab takes on the assigned color (and
the text of the tab name changes to white if the selected color is sufficiently
dark enough that black lettering is impossible to read).
To remove a color from a tab, right-click the sheet tab and highlight the Tab
Color option to open the Tab Color pop-up palette. Then, click No Color at the
bottom of the Tab Color palette.
Getting your sheets in order
Sometimes, you may find that you need to change the order in which the
sheets appear in the workbook. Excel makes this possible by letting you drag
the tab of the sheet you want to arrange in the workbook to the place where
you want to insert it. While you drag the tab, the mouse or Touch Pointer
changes to a sheet icon with an arrowhead on it, and the program marks
your progress among the sheet tabs (see Figures 7-2 and 7-3 for examples).
When you release the mouse button, Excel reorders the worksheets in the
workbook by inserting the sheet at the place where you dropped the tab off.
to the front