How to restrict document editing in Microsoft Office

When sharing an Office document with colleagues or a group, making sure the content remains accurate is critical. Although you can add a password to protect a document, people with access can still make unwanted changes, which can result in delays or communication of the wrong information.

If you use Office 365, Office 2019, or an older version, you can use several features to restrict editing to a section or entire document, spreadsheet, or presentation to prevent users from making changes accidentally.

In this Windows 10 guide, we walk you through multiple methods to restrict document editing and prevent accidental changes on Word, Excel, and PowerPoint documents.

• How to prevent unwanted edits by restricting changes in Microsoft Office
• How to prevent unwanted edits using the read-only option in Microsoft Office
• How to prevent unwanted edits by marking documents as final in Microsoft Office

How to prevent unwanted edits by restricting changes in Microsoft Office

In Microsoft Office, you can use the restrict editing tools to control formatting, style, and the types of content users are allowed to update to prevent unwanted changes.

Restricting modifications in Word

To restrict style and formatting editing in Word, use these steps:

1. Open the Word document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect document menu.

5. Select the Restrict Editing option.

   

6. Under the "Formatting restrictions" section, check the Limit formatting to a selection of styles option.

   

7. Click the Settings option.

8. Clear the styles that you want to restrict from editing.

   

   Tip: You can also use the "All," "Recommended Minimum," and "None" buttons to quickly allow or deny a group of styles.

9. (Optional) Under the "Formatting" section, select the formatting that you want to allow or deny:

   • Allow AutoFormat to override formatting restrictions.
   • Block Theme or Scheme switching.
   • Block Quick Style Set switching.
10. Click the OK button.

11. Click the Yes button to remove (or the No button to retain the original changes) formatting or styles that are now restricted.

    

12. Check the Allow only this type of editing in the document option.

    

13. Use the drop-down menu to select an option that best suits your situation, including:

    • No changes (Read only).
    • Tracked changes.
    • Comments.
    • Filling in forms.

    Tip: If you want users to only view the content while preventing unintentional changes, use the "No changes (Read only)" option and set a password on step No. 17.

14. (Optional) Using the mouse, select the part of the document that users are allowed to edit without restrictions.

15. Under the Exceptions section, select the group or user (click the More users option) you want to allow to edit the part of the document selected.

    

16. Under the "Start enforcement" section, select the Yes, Start Enforcing Protection button.

    

17. (Optional) Select the Password option.

    

18. Click the OK button.

Once you complete these steps, the application will block users from making unwanted changes based on your configuration.

If you change your mind, you can always revert the settings using the same instructions, but on step No. 6, click the Stop Protection button at the bottom of the "Restrict Editing" pane in the right side.

Restricting modifications in Excel

To restrict editing to a sheet in Excel, use these steps:

1. Open the Excel document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect Workbook menu.

5. Select the Protect current sheet option.

   

6. (Optional) Set a password to unlock the sheet.
7. Check the Protect worksheet and contents of locked cells option.

8. Select the edits users are allowed to make.

   

9. Click the OK button.
10. Re-enter the password to confirm.
11. Click the OK button.

After completing the steps, users will only be allowed to make changes based on the settings that you specified.

If you no longer need to protect an Excel sheet, you can revert the changes using the same instructions, but on step No. 4, make sure to click the Unprotect option on the right side.

Protect workbook structure

In addition to restricting edits to the sheet, you can also prevent unwanted changes to the structure of the workbook with these steps:

1. Open the Excel document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect Workbook menu.

5. Select the Protect Workbook Structure option.

   

6. (Optional) Set a password to allow changes.

7. Under the "Protect workbook for" section, check the Structure option.

   

8. Click the OK button.
9. Re-enter the password to confirm.
10. Click the OK button.

Once you complete these steps, users won't be able to modify the structure of the workbook, including adding, moving, deleting, hiding or renaming worksheets.

You can always undo the changes using the same instructions until step No. 5.

How to prevent unwanted edits using the read-only option in Microsoft Office

If you don't want anyone to make accidental changes to a Word, Excel, or PowerPoint document, you can configure the file to always open as read-only.

To open a document always in read-only mode, use these steps:

1. Open the Office document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect document menu.

5. Select the Always Open Read-Only option.

   

After completing these steps, the document will always open in read-only mode to prevent accidental changes. If you must input an update, close and re-open the document, and click the No button in the dialog box.

How to prevent unwanted edits by marking documents as final in Microsoft Office

Alternatively, you can also mark a Word, Excel, and PowerPoint document as final to prevent unintentional changes.

To mark an Office document as final, use these steps:

1. Open the Office document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect document menu.

5. Select the Mark as Final option.

   

6. Click the OK button.
7. Click the OK button again.

Once you complete these steps, the document will be marked as final, and as a result, changing comments, typing, and proofing will be disabled, preventing users from making changes.

You can always undo the setting using the same instructions until step No. 5.

While marking a document as final disables editing, users will still able to unlock the document to make changes. However, it's a handy feature to let users know that the file has been finalized and to prevent unintentional changes that can go unnoticed.

More Windows 10 resources

For more helpful articles, coverage, and answers to common questions about Windows 10, visit the following resources:

• Windows 10 on Windows Central – All you need to know
• Windows 10 help, tips, and tricks
• Windows 10 forums on Windows Central