Microsoft Office Tutorials and References
In Depth Information
Note that you can copy the sheet(s) to a different open workbook, too. Clicking Create a copy will do
just that, replicating the sheet (including all its data) and placing it in the first position among the
sheets (though obviously you can go ahead and move it). Copying a sheet coins a new sheet name
based on the copied sheet, e.g., Sheet 2 (2).
Tip You can also move a sheet by clicking the sheet tab (left button, this time), dragging it to its new position
among the tabs, and releasing the mouse when you’ve reached your destination. A small page icon will
accompany you as your drag, letting you know that sheet move is in progress.
And you can also recolor the sheet tab. Right-click the tab, select Tab Color , an d se l e ct y our hue
from the resulting color selection. (Note: Your new color won’t actually appear in the tab until you click
on a di ffe r e n t tab.)
You can al so hide entire worksheets, raising the obvious question as to why you’d want to. The
principal reason isn’t a desire to conceal the sheet from the dark intentions of industrial spies,
cov e tous col l e ag ue s, or assor te d othe r bad g uy s, be cause hi dde n wor kshe e ts can be r e v e al e d e asi l y
(there are Visual Basic programming means for securing the sheet with a password, though). Rather,
you may want to hide a sheet because it contains complex formulas you’d rather not overwrite, or
because all those calculations are unsightly (you can also protect all or part of a worksheet for much the
same reasons, but protection options leave the sheet in view. More on protection a bit later.) Keep in
mind that hidden worksheets remain active; that is, all their data and formulas continue to be
available in the workbook, and can still be referenced by formulas in the visible sheets.
To hide a worksheet, right-click the sheet you want to hide and select Hide Worksheet . That’s all.
You can also execute the Hide command by clicking on the Home tab Cells in the Format button
group Hi de & Un hi de Hide Sheet (I suspect you’ll find the first approach just a bit more efficient).
Note a s we l l tha t y ou ca n ca r r y out the Mov e or Copy, Re n a me , or T a b Col or cha n g e comma n ds v i a the
Format button, too. To reveal a hidden sheet or sheets—say we’ve hidden Sheet 3—right-click
anywhere among the still-visible worksheet tabs and click Unhide (rather an inelegant verb, but Excel
seems to be fond of it). You’ll see (Figure 7–10):