Microsoft Office Tutorials and References
In Depth Information
Hide a Worksheet
Hide a
Worksheet
You can hide a worksheet so that it no longer
appears in the workbook. This is useful if you
need to show the workbook to other people,
but the workbook contains a worksheet with
sensitive data that you do not want them
to see.
Another common reason to hide a worksheet is
to avoid having other people edit, add to, or
delete data on the worksheet. Although it is
relatively easy for someone to unhide a
worksheet, most people do not look for hidden
worksheets, so hiding the worksheet is a quick
and simple data protection measure.
If you want to ensure that another person
cannot unhide the worksheet, then you must
protect the workbook’s structure. For more
information, see the section, “Protect a
Workbook’s Windows and Structure.”
Hide a Worksheet
1 Click the tab of the
worksheet you want to
hide.
2 Click the Home tab.
3 Click Format.
4 Click Hide & Unhide.
5 Click Hide Sheet.
You can also right-click
the worksheet tab and
then click Hide Sheet.
2
3
4
5
1
Excel temporarily
removes the worksheet
from the workbook.
 
Search JabSto ::




Custom Search