Reviewing and Sharing Workbooks

In Excel track changes and comments when proofreading worksheets. Also share Excel workbooks with others easily.

Protecting your workbook

By default, anyone with access to your workbook will be able to open, copy, and change any part of it unless you protect it. There are many ways you can protect your workbook, depending on your needs. For example, you can mark your workbook as final, set it up with a password, put restrictions on who can make changes, or make it so only certain cells or features of the workbook are changeable.

To protect your workbook:

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click the Protect Workbook command.
  3. Choose the option that best suits your needs. In this example, we'll select Mark as Final. Marking your workbook as final is a way to discourage others from making changes to the workbook. It will alert whoever opens it that typing, editing, and proofreading commands are unavailable.
    Selecting a Protect Workbook optionSelecting a Protect Workbook option
  4. Click OK.
    Marking the workbook as finalMarking the workbook as final
  5. Another dialog box will appear. Click OK to confirm.
    Selecting the Inspect Document command Selecting the Inspect Document command