How to Protect a Worksheet in Excel (6 Effective Ways)

Sometimes, you need to share some sensitive Excel files. Being sensitive, it is essential that the excel file is not changed or edited by someone else. So, it would be a great help, if you know how to protect a worksheet in Excel. In this article, I will show you how to protect a worksheet in Excel using 6 effective ways.


Practice Workbook

You can download and practice from our workbook here.


6 Effective Ways to Protect a Worksheet in Excel

1. Protect a Spreadsheet with Password

You can protect your spreadsheet with a password. This will make your file protected from edits. And, you can also edit your file later with the password. Follow the steps below to do this:

Steps:

  • At first, click on the File tab from the ribbon.

  • At this time, click on the Info button from the expanded File tab.

  • Subsequently, the Info window will open. Now, click on Protect Workbook >> click on Encrypt with Password.

How to Protect a Worksheet in Excel

  • At this time, the Encrypt Document window will open. It will ask you to set a password. Enter your password in the text box and click on the OK button.

How to Protect a Worksheet in Excel

  • Now, the Confirm Password window will open. Reenter your password inside the text box and click on the OK button.

How to Protect a Worksheet in Excel

Thus, every worksheet of your workbook will be encrypted with a password. You will see the following things afterward. 👇  You will see that anybody who opens the file now, will be asked to enter the password. And only after giving the password, the file will open.

Read More: How to Protect Excel Sheet with Password (3 Quick Approaches)


2. Make a Spreadsheet as Read-Only

You can protect your workbook by making it a Read-Only file. Doing this will result in a prompt message warning you to open this file as read-only. Follow the steps below to do so:

Steps:

  • At first, click on the File tab from the ribbon.

  • At this time, click on the Info option from the expanded File tab.

  • Now, the Info window will open.  Now, click on Protect Workbook >> click on  Always Open Read-Only.

How to Protect a Worksheet in Excel

Thus, your file will be protected in Read-Only mode. You will see, when opening the file again, it will show you a message warning you to open the file as a read-only file.

How to Protect a Worksheet in Excel

Read More: How to Protect Excel Sheet from Viewing Using Password


3. Protect Excel Worksheets from Modifying

If you want to open your file, but don’t want to modify it, you can use the following steps below:

Steps:

  •  At first, click on the File tab from the ribbon.

  • Click on the Save As option from the expanded File tab.

  • Now, click on the Tools option from the Save As window and select General Options… from the listed options.

How to Protect a Worksheet in Excel

  • Subsequently, the General Options window will open. Here, you can set a password to open and modify. Now, enter your password inside the Password to modify the text box.

How to Protect a Worksheet in Excel

  • At this time, the Confirm Password window will open. Reenter your password inside the text box.

How to Protect a Worksheet in Excel

Now, If you open the file, you will see that the file wants a password for modification. If you don’t have the password, you can view the file as Read Only.

How to Protect a Worksheet in Excel

Read More: How to Protect Excel Sheet from Editing (7 Smart Ways)


Similar Readings


4. Protect a Worksheet with Customized Permissions

You can also allow specific permissions and protect your workbook. Follow the steps below to do so.

Steps:

  • Go to the Review tab from the ribbon >> Click on Protect Sheet >> Enter your password in the text box and click on the checkboxes according to your desired allowable permissions >> Click on the OK button.

How to Protect a Worksheet in Excel

  • At this time, the Confirm Password window will open. Reenter your password and click on the OK button.

How to Protect a Worksheet in Excel

  • You can also right-click on the Worksheet tab below and select Protect Sheet from the context menu.

How to Protect a Worksheet in Excel

  • Subsequently, the Protect Sheet window will open. And, you can select the allowable permissions and set a password like the 1st step’s last part.

Thus, your worksheet will be protected with allowable permissions.

Read More: Excel VBA: Protect Sheet with Password and Allow Filter


5. Protect Specific Cells in an Excel Worksheet

You can also protect specific cells of a worksheet. Follow the steps below:

Steps:

  •  At first, select the cells you want to remain editable. Then right-click on the mouse and choose Format Cells… from the context menu.

How to Protect a Worksheet in Excel

  • Go to the Protection tab from the Format Cells window. Now, uncheck the locked option tick.

How to Protect a Worksheet in Excel

  • Now, you can protect your worksheet following the other ways described here. But, the selected cells will remain editable.

Finally, your worksheet is protected without your selected cells.

Read More: How to Protect an Excel Sheet Except for Certain Cells (2 Ways)


6. Protect a Spreadsheet with ‘Mark as Final’ Feature

You can also use Mark as the Final feature to protect your worksheet. Follow the steps below to do so.

Steps:

  • At first, click on the File tab from the ribbon.

  • At this time, click on the Info option from the expanded File tab.

  • Subsequently, the Info window will open. Now, click on Protect Workbook >> click on Mark as Final.

How to Protect a Worksheet in Excel

  • Now, A dialogue box will warn you if you want your worksheet to mark as final. Click on the OK button.

Thus, your worksheet is protected. You will be warned that this file is marked as final, whenever you open the file.

Read More: Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)


How to Protect a Workbook Structure

You can also protect your workbook structure. In this way, you can still edit the values of cells, but you can not access the structural commands. Follow the below steps to do so:

Steps:

  • At first, click on the File tab from the ribbon.

 

  • At this time, click on the Info option from the expanded File tab.

  • Subsequently, the Info window will open. Now, click on Protect Workbook >> click on Protect Workbook Structure.

How to Protect a Worksheet in Excel

  • Now, Protect Structure and Windows window will open. Here, you can see, that the tick mark is on the Structure option only. Now, you can enter a password in the text box and click on the OK button. It is optional to put a password in this approach.

How to Protect a Worksheet in Excel

  • If you set a password, then Confirm Password window will open. Reenter your password in the text box and click on the OK button.

How to Protect a Worksheet in Excel

Thus, your workbook structure will be protected. You will face the following things when opening the file. 👇

  • If you open the file, you will see, that the structural commands are greyed out. So, you can not access these.

  • To access these commands again, you have to go to the Review tab on the ribbon >> Click on Protect Workbook >> Enter the password in the Password text box and click on the OK button.

  • Now, you can see, that the structural commands can be accessed. But remember, once you do this, you will have to protect the workbook again.


Conclusion

So, here I have shown you how to protect an Excel worksheet in 6 effective ways. You can use any of these ways to protect your Excel cells, worksheets, or whole workbook according to your needs. I hope, you find this information informative and helpful. If you have any further queries or recommendations, please feel free to contact me. And, visit ExcelDemy for many more articles like this.


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo