Hiding sheets

 

You may have a sheet or sheets in your workbook that contains confidential information or information that you do not update that often.  You can hide these sheets fro view as follows -
1. The sheet you want to hide should be the active sheet.
2. Click on Format -> Sheet -> Hide.  The sheet will be hidden.
(For Excel 2002, right click the sheet tab and select Hide).

To unhide the hidden sheet, click on Format->Sheet -> Unhide.  Select the sheet and click Ok.

For versions later than 2003, right click on the sheet and select hide/unhide.



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>