Microsoft Office Tutorials and References
In Depth Information
Saving workbooks or windows as hidden
Saving workbooks or windows as hidden
Sometimes you might want to hide a particular workbook, perhaps even to prevent
others from opening and viewing its sensitive contents in your absence. If so, you can save the
workbook as hidden. A hidden workbook is not visible when it’s opened. You can save a
workbook as hidden by following these steps:
Close all open workbooks other than the one you want to hide, and then click View,
Exit Excel.
When a message appears asking whether you want to save changes to the workbook,
click Save.
The next time the workbook opens, its contents are hidden. To ensure that it cannot be
unhidden by others, you might want to assign a password by clicking Review, Protect
Workbook before hiding and saving the workbook.
Hiding worksheets
If you want to hide a particular worksheet in a workbook, click the Home tab, and in the
Cells group, click Format. On the menu that appears, click Hide & Unhide, and then click
Hide Sheet. When you do so, the active worksheet no longer appears in the workbook. To
unhide a hidden worksheet, click Unhide Sheet on the same menu. This command becomes
active after you have hidden a worksheet. The Unhide dialog box for worksheets is almost
identical to the Unhide dialog box for workbooks shown in Figure 7-9. Select the worksheet
you want to unhide, and then click OK.
Marking as final
When you need to share your finished workbooks with others rather than distribute them
for collaboration, you might be interested in the Mark As Final command. Although anyone
can still open a workbook that has been marked as final, the fact that you marked it as final
helps your coworkers understand that it is a finished piece of work. Click the Info category
on the File tab, and then click the Protect Workbook button to display the menu shown in
Figure 7-12.
Search JabSto ::

Custom Search