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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube