Looking for some tricks to prevent your Excel data from being edited by any other user? Don’t go anywhere as this blog will help you out in exploring some best ways to protect Excel workbook from editing.
How To Protect Excel Workbook From Editing?
Following are some best approaches to protect excel workbook from editing. You can select any of the solution as per your requirement of applying security to your workbook, Worksheet, file or only to some specific cells.
Trick 1# Make Your Excel Workbook Read-Only
Making your Excel workbook read-only is the best option to protect workbook from editing by any user.
Though this excel feature won’t give real time protection to your excel workbook. Thus any user can easily remove this read-only restriction and enable the editing option.
But this will give a hint to other user for making any changes in the file very carefully.
Follow down the steps to make your Excel file read only.
Trick 2# Protect Excel Worksheet From Editing
Another way of preventing Excel workbook from editing is by protecting each individual worksheet.
Using this option you can easily lock all the cells from being edited by anyone. Protect Excel Worksheet means no can edit or delete its content.
Follow the below steps to Protect Excel Worksheet From Editing:
Following are some best approaches to protect excel workbook from editing. You can select any of the solution as per your requirement of applying security to your workbook, Worksheet, file or only to some specific cells.
Trick 1# Make Your Excel Workbook Read-Only
Making your Excel workbook read-only is the best option to protect workbook from editing by any user.
Though this excel feature won’t give real time protection to your excel workbook. Thus any user can easily remove this read-only restriction and enable the editing option.
But this will give a hint to other user for making any changes in the file very carefully.
Follow down the steps to make your Excel file read only.
- First of all open the Excel workbook in which you want to apply this read-only option.
- Choose the file > info> Protect Workbook option.
- In the protect workbook there is a drop-down list of option from which you have to choose “always open read only”.
- After this, you will see each time you tries to open the Excel file, you will immediately get the warning message that the file is in the read-only mode.
- In case you to remove this read-only option. For that just go to the File > Protect Workbook. Now turn off the “Always Open Read-Only” setting.
Trick 2# Protect Excel Worksheet From Editing
Another way of preventing Excel workbook from editing is by protecting each individual worksheet.
Using this option you can easily lock all the cells from being edited by anyone. Protect Excel Worksheet means no can edit or delete its content.
Follow the below steps to Protect Excel Worksheet From Editing:
- From the Excel ribbon tap to the “Review” tab.
- Now from the changes group make a tap on the “Protect Sheet.”
- Assign the password which you want to set for unlocking your Excel sheet in the future again.
- Enter the password one more time to make a confirmation and hit the ok.
- Choose the permissions from the listed option of “allow all users of this worksheet to” and then click the ok.
- For removing up the protection, go to the “Review” tab and hit the button “Unprotect Sheet”.
- Enter the password and click the “OK” button.
- Now your sheet is unprotected. So you have to apply for the protection again whenever you need it.