Excel 2019 Bible

(singke) #1

Chapter 34: Protecting Your Work


34


Inspecting a workbook


If you plan to distribute a workbook to others, you may want to have Excel check the file
for hidden data and personal information. This tool can locate hidden information about
you, your organization, or the workbook. In some situations, you may not want to share
this information with others.


To inspect a workbook, choose File ➪ Info ➪ Check for Issues ➪ Inspect Document. The
Document Inspector dialog box appears, as shown in Figure 34.9. Click Inspect, and Excel
displays the results of the inspection and gives you the opportunity to remove the items it
finds.


FIGURE 34.9


The Document Inspector dialog box identifies hidden and personal information in a work-
book.

Free download pdf