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.
3. 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.
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.
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.
7. Right-click and select Format Cells. You can also use the keyboard shortcut Ctrl + 1.
8. 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.
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.
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.
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!