How To Protect Cells In Excel

H

Wondering how to protect cells in Excel? Read the article to learn all about it and more.

A cell in Microsoft Excel is a rectangular box that appears in a spreadsheet at the junction of a vertical column and a horizontal row. We also know that we can add rows and columns as many as we wish along with any kind of data we require.

While working on an Excel sheet, there are times when you can accidentally delete or make changes that are not needed. To avoid such situations you can easily protect cells in excel. Let us find out how to do so in simple steps.

How To Protect Cells In Excel

This is one of the ways to protect cells in Excel.

1. Open Excel and select a workbook.

2. First we unlock the workbook, which is typically locked by default. For that, press Ctrl + A to select the entire document.

Press Ctrl + A to select the entire document.

3. Right-click and select Format Cells. 

Right-click and select Format Cells. 

4. Under the Protection tab, uncheck Locked. If it’s not checked by default, you’re ready to go. <uncheck.png>

5. Press OK. 

 Press OK. 

With your workbook now unlocked, you can now set about locking specific areas. In this tutorial, let’s pretend we’re responsible for Columns B, C, and D. 

Also Read
How to split cells in Excel
How to merge cells in Excel
How to unmerge cells in Excel

6. Select the area of the workbook to protect.

Select the area of the workbook to protect.

7. Right-click and select Format Cells. You can also use the keyboard shortcut Ctrl + 1.

Right-click and select Format Cells. You can also use the keyboard shortcut Ctrl + 1.

8. Check Locked and press OK.

Check Locked and press OK.

In an Excel workbook, nothing is ever locked until you protect the sheet. Let us now do that.

9. Under the Review tab, choose Protect Sheet.

Under the Review tab, choose Protect Sheet.

10. Add a password (if desired), and check on the options based on what you’d like other users to be able to edit in your protected section. To not let them do anything, uncheck each of the boxes and press OK

Uncheck each of the boxes and press OK. 

Nothing would happen if you try clicking in any of the three columns we protected. 

And this is how you protect cells in Excel based on your desires.

conclusion

Microsoft Excel is a Microsoft software program that uses spreadsheets to organize numbers and data using formulas and functions. Ordinary people can use Microsoft Excel to perform simple tasks such as calculating percentages, data filtering, and using pivot tables.

EasySheet is a tech blog that features incredible Excel hacks, tips, and tricks. Our goal with the EasySheet is to aid beginners learn Excel and find answers to all of their questions.

We are the best place to go for anyone who needs assistance with Microsoft Office applications such as Excel, Word, PowerPoint, Publisher, and more!

About the author

Gaurav Singh Rawat

Add comment