How to Protect Sheet in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Protect Sheet in Excel



In this tutorial, you will learn how to protect sheet in excel. Knowing how to lock excel sheet is very useful especially if you want the data on your worksheet in this software to be not modified carelessly.


Why do We Need to Learn How to Excel Sheet Protect?


When we need to do data processing in a spreadsheet, maybe there is a need to guard the data or formula that we have in our worksheet. This need happens when the data or formula is important and permanent so they do not need to be changed anymore. Moreover, maybe if they are changed, then the result of our analysis will be wrong or there will be errors on some of the data processing that we have done. Try to keep our data processing correct is important in spreadsheets and knowing how to do it in our worksheet is one of the most useful things that we can understand in using this software.

As an example for the application of this protection need in our job, let’s say we are doing data processing for the production capacity and allocation for each of the company’s products to the factory machines. Maybe there are some data that is permanent like the production capacity or the machine names so we do not need to change them again when we do the processing. There are also some formulas for the capacity and allocation analysis that we have written and we want to protect them from modification so the analysis that we have done does not result in an error. For that, we need a way so the data and formula are protected so they are not modified on purpose or accidentally that can result in the error of our analysis.

To help to solve this need, then you can practice the function of how to protect sheet in excel. This function is very important to be understood by every user of this software especially when doing a complex data processing because there is usually a time in the processing when there is a desire to protect the content of a worksheet. That is when you need to practice your understanding on how to do it in this spreadsheet tool.


What is How to Protect Sheet in Excel?


How to protect sheet in excel is a function with the usage objective to protect the data or formula in your worksheet from revision or modification. Usually, you will add a password in the protection function so it will be safer if there are other people besides you who use the spreadsheet file and you don’t want those other people to change the content of some particular worksheets in it.


How to Lock Worksheet in Excel?


The following will explain how to protect sheet in excel step-by-step. This method can only be used one by one on the worksheets that you have in your spreadsheet file, it cannot be used to more than one worksheet directly. If you want to directly protect more than one worksheet, then you must use VBA.


How to Protect Sheet in Excel

  1. Right-click on the sheet that you want to lock

    How to Protect Sheet in Excel - Screenshot of Step 1

  2. Choose Protect Sheet…

    How to Protect Sheet in Excel - Screenshot of Step 2

  3. Input the password that will be asked when someone wants to unprotect the sheet later, twice in the two text boxes provided. You can also not inputting a password if you feel there is no need for it (To unprotect it later, people will just need to click Unprotect on the worksheet if you do not put in a particular password)

    How to Protect Sheet in Excel - Screenshot of Step 3

  4. Set what is allowed and not allowed to be done on the sheet when it is protected in the checkboxes at the bottom

    How to Protect Sheet in Excel - Screenshot of Step 4

  5. Click OK after all the steps above are done

    How to Protect Sheet in Excel - Screenshot of Step 5

  6. It is done!


Exercise


After learning the steps of how to protect sheet in excel, now is the time to try practicing it to sharpen your understanding. Open a new spreadsheet file and do the steps from the tutorial on one of the worksheets in there. What is the result and can you do it?


Additional Note


If you want to know how to lock certain cells in excel and unlock the others in your worksheet when it is protected, then this is the way. You can set whether it is locked or unlocked in the Format Cell menu of the cell. Right-click in the cell that you want to set and choose Format Cell

How to Protect Sheet in Excel - Screenshot of Additional Note 1

Then in the Protection tab, check the Locked checkbox if you want the cell cannot be edited when the worksheet is protected and uncheck if you want it to be able to be edited. Then click OK.

How to Protect Sheet in Excel - Screenshot of Additional Note 2

How to Protect Sheet in Excel - Screenshot of Additional Note 3





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert