How to Protect Excel Workbook from Editing (5 Effective Methods)

You may want to protect your Excel worksheet while sending an Excel file to your colleagues. In this article, I’ve discussed 5 effective methods to protect an Excel workbook from editing.


5 Methods to Protect Excel Workbook from Editing

1. Using ‘Open as Read-Only’ Feature to Protect Workbook from Editing

You can mark your Excel workbook as a Read-Only file. Thus, when someone else attempts to open the Excel file, it will primarily protect the workbook from editing.

This method offers the least protection for your Excel workbook. Because it doesn’t require any password to enter and edit an Excel file.

❶ At first go to the File tab.

Selecting File tab to Protect Excel Workbook from Editing

❷ Now go to Info Protect Workbook Always Open Read-Only.

Using Open as Read-Only feature to Protect an Excel Workbook from Editing

This will shift your Excel workbook to Read-Only mode.

Thus, when someone else will try to open the Excel file, it will show the following dialog box:

Hitting Yes to proceed with the Read-Only mode. But hitting No will enable editing the workbook.

Read More: Protect and Share Excel Workbook (2 Quick Methods)


2. Encrypting with Password to Protect Excel Workbook from Editing

This method offers powerful protection for your Excel workbook. Because it requires a password for someone to access the editing of an Excel workbook.

❶ First, go to File.

Selecting File tab to Protect Excel Workbook from Editing

❷ Then, go to Info Protect Workbook Encrypt with Password.

Encrypting with a Password to Protect an Excel Workbook from Editing

❸ Now, insert a password in the Encrypt Document dialog box.

❹ After that, re-enter the password in the Confirm Password dialog box.

That’s all you need to do.

When you re-open the Excel workbook, it requires a password to insert in the Password dialog box.

Read More: Top Excel Security Tips: Features for securing worksheets and workbooks


3. Using Protect Workbook Structure to Protect Workbook

You can also use the Protect Workbook Structure feature.

For that,

❶ Go to File.

Selecting File tab to Protect Excel Workbook from Editing

❷ Then, go to InfoProtect Workbook Protect Workbook Structure.

Using Protect Workbook Structure to Protect Workbook

❸ Insert a password in the Protect Structure and Win dialog box.

❹ Re-enter the password in the Confirm Password dialog box and hit OK.

This will encrypt your Excel workbook with a password.

If you want to unlock your Excel workbook,

❶ Just go to the Review tab.

❷ Click on Protect Workbook.

❸ Now, insert your password into the Unprotect Workbook dialog box.

❹ Then, hit OK.

This will unprotect the Excel workbook and you will have access to the editing.


4. Using Protect Workbook Command

The next way to protect an Excel workbook from editing is to use the Protect Workbook command.

For that,

❶ Just go to the Review tab.

❷ Click on Protect Workbook.

Protect Workbook from Editing Using Protect Workbook Command

❸ Insert a password in the Protect Structure and Win dialog box.

❹ Re-enter the password in the Confirm Password dialog box and hit OK.

This will encrypt your Excel workbook with a password and protect it from editing.

If you want to unlock your Excel workbook,

❶ Just go to the Review tab.

❷ Click on Protect Workbook.

❸ Now, insert your password into the Unprotect Workbook dialog box.

❹ Then, hit OK.

This will unprotect the Excel workbook and you will have access to the editing.

Read More: [Fixed!] Protect Workbook in Excel Not Working (with Quick Solution)


5. Using ‘Mark as Final’ to Protect Workbook from Editing

Another way to protect an Excel workbook from editing is to mark a version of an Excel workbook as a final copy.

Thus, when someone will open the Excel file, it will warn them that, it’s the final version and they shouldn’t edit it.

To mark an Excel workbook as a final version,

❶ Go to File first.

Selecting File tab to Protect Excel Workbook from Editing

❷ Then, go to Info Protect Workbook Mark as Final.

Using ‘Mark as Final’ to Protect an Excel Workbook from Editing

❸ Then, a small dialog box will appear. Just hit OK in it.

Excel will automatically mark your Excel workbook as a final version.

When someone else will try to open the workbook, Excel will show the following warning box.

To proceed,

  • Just hit OK.

If you want to edit the workbook further, just click Edit Anyway.

Using ‘Mark as Final’ to Protect an Excel Workbook from Editing

Then, Excel will access you to edit the workbook.

Read More: Excel Protection Explained: Worksheet vs. Workbook Level Protection


Conclusion

To sum up, we have discussed 5 methods to protect an Excel workbook from editing. You are recommended to download the practice workbook attached with this article and practice all the methods. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.


Related Article

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo