Explanation

Excel provides tools to protect workbooks and check them for potential issues before sharing.

Protect Workbook

Workbook protection can help control changes to workbook structure.

Depending on the Excel version, protection options may include:

  • Protect Workbook
  • Password protection
  • Restricting structural changes

Inspect Workbook

The Inspect Workbook tools can help identify information that may need attention before sharing a file.

Examples can include:

  • Hidden information
  • Document properties
  • Personal information
  • Compatibility issues

Manage Workbook

Manage Workbook can help you access or recover previous versions or unsaved/recovered files when supported by your Excel environment.

Practice

Create a workbook with multiple worksheets and explore the workbook protection options.

Then open the inspection tools and review the available checks.

PreviousNext