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

You may need to secure your data when dealing with confidential analysis. When you wish to protect individual cells in a worksheet, however, it becomes a task. So, we are here to show you how to protect an Excel sheet except for certain cells.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Handy Approaches to Protect an Excel Sheet Except for Certain Cells

In the figure below, we’ve offered a data set in which we will protect the whole sheet except for a few cells. In the first approach, we’ll use the Review tab in Excel to secure the particular cells. Later on, we will use the Format Cells option to do the same.

Sample Data

1. Use Protect Ribbon to Protect an Excel Sheet Except for Certain Cells

Step 1: Use the Review Tab

  • Firstly, click on the Review tab.
  • From the Protect ribbon, select the Allow Edit Ranges.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 2: Select the Range/Cells

  • Click on the New option.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • Select the ranges (C5:C14) or cells to keep them unprotected from the whole sheet.
  • Then, press Enter.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 3: Protect Sheet

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • Type any password (e. 1234) you prefer.
  • Press Enter.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • Retype the password again to confirm.
  • Then, click OK.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 4: Final Result

  • Try to edit any cell except the range you selected.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • Therefore, it will show the warning message that the cells are protected.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • On the other hand, try to edit any cell (C5) from your selected range (C5:C14).
  • Consequently, you can edit the cell as the cell (C5) is unprotected.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Notes. To unprotect the cells, follow the steps below:

Step 1: Utilize the Review Tab

  • Firstly, click on the Review tab.
  • Then, click on the Unprotect Sheet.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 2: Enter Password

  • Type the password (e., 1234) you used to protect the sheet.
  • Then, click OK.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

  • Therefore, you can now edit any cell as all the cells are unprotected.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

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


Similar Readings


2. Utilize Format Cells Option to Protect an Excel Sheet Except for Certain Cells

We can use the Format Cells option to separate the selected cells and then protect the whole sheet. Thus, the whole sheet will be protected without the cells we will select. Follow the outlined steps below to do the task.

Step 1: Select Cells Or Range

  • To select multiple cells, hold the Ctrl key and click on the preferred cells.
  • As you can see, we have selected cells C5, C7, C9, and C10.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 2: Open the Format Cells Dialog Box

  • Right-click the mouse over the selection of cells.
  • To open the Format Cells box, select the Format Cells option from the list.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Step 3: Use the Protection Tab

  • In the Format Cells box, click on the Protection
  • Uncheck the Locked option.
  • Then, click OK.

Handy Approaches to Protect an Excel Sheet Except for Certain Cells

Notes. By default, in Excel Format Cells, the Locked option is enabled. Disabling the Locked option for selected cells means the selected cells will be unprotected.

Step 4: Protect the Sheet

  • Go to the Review tab and click on the Protect Sheet command.

Sample Data

  • Enter a password (e., 1234) you prefer.
  • Then, press Enter.

Sample Data

  • Retype the password to make the confirmation.
  • Finally, click OK.

Sample Data

  • As a result, if you attempt to change any cells that are not part of your selection, a warning message will appear informing you that the cells are protected.

Sample Data

  • If you try to edit any cell that was in your selection, you can edit the cells without any complexity.

Sample Data

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


Conclusion

I hope this article has given you a tutorial about how to protect an Excel sheet except for certain cells. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

Please contact us if you have any questions. Also, feel free to leave comments in the section below.

We, the ExcelDemy Team, are always responsive to your queries.

Stay with us and keep learning.


Related Articles

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo