Restrict changes to files in Word and Excel

If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions.

Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it. For more information, see Restrict changes to files and Make a document read-only.

Restrict changes in Word

  1. On the Review tab, in the Protect group, click Restrict Editing.

    Protect document options

    The Restrict Formatting and Editing pane appears.

    Restrict Editing pane

  2. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs.

For more protection options, click File > Protect Document.

Protect document

Restrict changes in Excel

On the Review tab, in the Protect group, review the following protection options:

Protect workbook options

  • Protect Sheet    Protect the worksheet and contents of locked cells.

  • Protect Workbook    Protect the workbook for structure and Windows.

  • Allow Edit Ranges    Determine what ranges can be edited.

For more protection options, click File > Protect Workbook.

Protect workbook

Restrict changes in Word

  1. On the Review tab, in the Protect group, click Restrict Editing.

    Protect document

  2. The Restrict Formatting and Editing pane appears.

    Restrict Editing pane

  3. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs.

For more protection options, click File > Protect Document.

Protect document

Restrict changes in Excel

On the Review tab, in the Changes group, review the following protection options:

Protect worksheet options

  • Protect Sheet    Protect the worksheet and contents of locked cells.

  • Protect Workbook    Protect the workbook for structure and Windows.

  • Protect and Share Workbook    Prevents removal of tracked changes.

  • Allow Users to Edit Ranges    Determine what ranges can be edited.

For more protection options, click File > Protect Workbook.

Protect workbook

See also

Make a document read-only

Restrict changes to files

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×