Chapter 6: Understanding Excel Files and Templates
6
Protect Current Sheet This command lets you protect various elements of a worksheet. It
displays the same dialog box as the Review ➪ Protect ➪ Protect Sheet command.
Protect Workbook Structure This command lets you protect the structure of a workbook.
It displays the same dialog box as Review ➪ Protect ➪ Protect Workbook.
Restrict Access If your organization uses the Azure Rights Management System, you can
connect your workbook to it and get more granular options for protecting it.
Add a Digital Signature This command allows you to “sign” a workbook digitally so that
users can trust that you signed it.
Mark as Final Use this option to designate the workbook as “final.” The document is
saved as a read-only file to prevent changes. This isn’t a security feature. Rather, the Mark
as Final command is useful to let others know that you’re sharing a completed version of a
workbook.
See Chapter 34, “Protecting Your Work,” for more information about protecting worksheets, protecting
workbooks, and using digital signatures.Check for Issues options
The File ➪ Info ➪ Check for Issues drop-down list contains the following options:
Inspect Document This command displays the Document Inspector dialog box.
The Document Inspector can alert you to some potentially private information that may be
contained in your workbook—perhaps information that’s contained in hidden rows or col-
umns or hidden worksheets. If you plan to make a workbook available to a large audience,
it’s an excellent idea to use the Document Inspector for a final check.
Check Accessibility This command checks the workbook for potential problems that
might occur for people with disabilities. The results of the check are displayed in a task
pane in the workbook.
Check Compatibility This command is useful if you need to save your workbook in an
older file format. It displays a helpful Compatibility Checker dialog box that lists potential
compatibility problems. This dialog box also appears when you save a workbook using an
older file format.
Manage Workbook options
If Excel automatically saved previous versions of your workbook, you can recover one of the
earlier versions.
Browser View options
If your workbook will be viewed in a web browser, you can specify which sheets and other
objects will be viewable.