Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
The Document Inspector checks your document for every category of information
that is selected in the list. Clear the check box of any type of information you want
to remain in the workbook, and then click Inspect. In the inspection results dialog
box that appears, click the Remove All button to the right of any data you want to
remove.
When you’re done making changes to a workbook, you can mark it as final. Marking
a workbook as final sets the status property to Final and turns off data entry and
editing commands. To mark a workbook as final, display the Info page of the Backstage
view, click Protect Workbook, click Mark As Final, and then click OK to verify that you
want to finalize the workbook.
To restore functionality to a workbook that has been marked as final, display the Info
page of the Backstage view, click Protect Workbook, and then click Mark As Final to
change its status.
To inspect and remove hidden or personal information, follow these steps:
Press Ctrl+S to save the file.
1
Display the Info page of the Backstage view, click Check for Issues , and then
click Inspect Document to open the Document Inspector dialog box.
2
Clear the check box of any content type that you want to remain in the
document, and click Inspect .
3
In the inspection results list, click the Remove All button to the right of any
category of data that you want to remove.
4
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 Display the Info page of the Backstage view, click Protect Workbook , and then
click Mark as Final .
2 In the message box that indicates that the file will be marked as final and then
saved, click OK .
3 In the message box that indicates that the file has been marked as final,
click OK .
 
Search JabSto ::




Custom Search