Microsoft Office Tutorials and References
In Depth Information
Hiding and protecting workbooks
Hiding and protecting workbooks
Sometimes you might want to keep certain information out of sight or protect it from
inadvertent modification. You can conceal and protect your data by hiding windows,
workbooks, or individual worksheets from view.
For information about protecting individual cells, see “Protecting worksheets” in Chapter 6.
Hiding workbooks
At times, you might need to keep a workbook open so that you can access the information
it contains, but you don’t want it to be visible, either for convenience or for security. When
several open workbooks clutter your workspace, you can click the Hide button on the View
tab to conceal some of them. Excel can still work with the information in the hidden
workbooks, but they don’t take up space on your screen, and their file names don’t appear in
the Switch Windows menu on the View tab.
To hide a workbook, activate it and then click View, Hide. Excel removes the workbook from
view, but the workbook remains open and available in the workspace. To bring the hidden
workbook into view, click View, Unhide, and then select the name of the hidden workbook.
The Unhide command is available only when you have a workbook hidden. The Unhide
dialog box, shown in Figure 7-9, lists all the hidden workbooks.
Figure 7-9 The Unhide dialog box lists all the workbooks you currently have hidden.
Search JabSto ::

Custom Search