Microsoft Office Tutorials and References
In Depth Information
Hiding Data
5. Select the checkboxes for the type of data
you want to search for and possibly remove.
Be Careful When Removing
Hidden Data
6. Click Inspect.
If you remove hidden data, you might not
be able to use Undo to get it back.
7.
The Document Inspector looks for the type
of data you selected, and then displays a list
of the items it has found, as shown in Figure
13-2. To remove a particular type of data,
such as the Document Properties and
Personal Information, click that data’s
Remove All button.
8. Repeat Step 7 to remove the various data
types you want.
9. When you’re through removing data, click
Close.
10.
Save your workbook again by clicking the
Save button on the Quick Access Toolbar.
Figure 13-2
The Document Inspector reports on hidden data.
Hiding Data
If your workbook contains private
company data or confidential information, you
do not need to show it if you don’t want to—you
can hide it instead. In addition, if a workbook
contains data that simply supports the main data,
there’s no need to bore people with it—hide it
from view so the workbook’s most important
data remains the focus. In Chapter 6, “Managing
Large Amounts of Excel Data,” you learned how
to hide rows and columns, and even a single cell’s
data. In this section, you learn how to hide an
entire worksheet or workbook.
Tip
Hiding data does not prevent it from
being seen by prying eyes. You must
protect the worksheet or workbook to
prevent users from simply redisplaying
them. See the section “Protecting Data”
for help.
 
 
Search JabSto ::




Custom Search