Microsoft Office Tutorials and References
In Depth Information
Keeping Workbooks Secure
Keeping Workbooks Secure
Worksheets often contain
numerical information that is
confidential in nature, such as financial or payroll
data. In today’s world of electronic snooping, it’s
up to you to protect your work against prying eyes.
Fortunately, Excel provides a large number of
security tools such as password protection, hiding
sensitive worksheet areas, or locking data against
unwanted changes.
Hiding a Workbook
Suppose you are working on a payroll benefits
report and nosy Ned approaches to ask you a
question. You don’t want him to see your work, so you
need to quickly hide it from his view. To shelter
your work from curious onlookers, you simply
choose View>Window>Hide. Excel hides the
current workbook, leaving the Excel program open and
visible. If you have another workbook open, you see
that workbook but not the hidden workbook.
Figure 12-1
Redisplaying a hidden workbook.
Minimize All Windows
Press the Windows key plus the M key to
quickly minimize all open items and display
the Windows desktop.
To redisplay the workbook, choose View>
Windows>Unhide. (If no workbooks are hidden,
the Unhide button is unavailable.) Excel displays
the Unhide dialog box listing all hidden
workbooks, as you see in Figure 12-1. Select the
workbook to unhide and click OK.
Inspecting for Private
Information
In Chapter 7, “Discovering Word Tools,” you
discovered the Document Inspector, which searched
through Word documents for metadata. Excel also
provides the Document Inspector which can help
remove hidden information that you might not
want others to see. Just follow these steps:
Search JabSto ::




Custom Search