Microsoft Office Tutorials and References
In Depth Information
Finalizing a Workbook
Distributing a workbook to other users carries many risks, not the least of which
is the possibility that the workbook might contain private information you don’t
want to share with users outside your organization. With Excel, you can inspect a
workbook for information you might not want to distribute to other people, and
create a read-only final version that prevents other people from making changes
to the workbook content.
Using the Document Inspector, you can quickly locate comments and annotations,
document properties and personal information, custom XML data, headers and
footers, hidden rows and columns, hidden worksheets, and invisible content. You
can then easily remove any hidden or personal information that the Document
To inspect and remove hidden or personal information, follow these steps:
1. Save the file.
2. Click the File tab, and then, on the Info page of the Backstage view, click Check
for Issues, and then click Inspect Document.
3. In the Document Inspector window, clear the check box of any content type
you want to remain in the document, and click Inspect.
4. In the inspection results list, click the Remove All button to the right of any
category of data you want to remove.
Marking a workbook as final sets the status property to Final and turns off data entry,
editing commands, and proofreading marks.
To mark a workbook as final, follow these steps:
1. Click the File tab, and then, on the Info page of the Backstage view, click
Protect Workbook, and then click Mark as Final.
2. In the message box indicating that the file will be marked as final and then
saved, click OK.
3. In the message box indicating that the file has been marked as final, click OK.
To restore functionality to a workbook that has been marked as final, click the File tab
and then, on the Info page of the Backstage view, click Protect Workbook, and then
click Mark As Final to change its status.