Hiding Worksheets in Microsoft Excel 2010

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):