How To Lock(Protect) Cells In Excel ?| What is Microsoft Excel

Hi everyone, welcome to the Trakin Tech website. In this session, we will learn how to protect and lock cells in Excel.

Why do we need to lock or protect cells in Excel? Let's imagine there is an excel spreadsheet with really sensitive data and you need to give that data to your subordinate or you need to make some minor changes now. Imagine if you only want the changes to be in one or two columns and the rest of the columns should be left as they are now, there is a high chance that your colleague or subordinate may sometimes unwittingly or unintentionally make some changes. To avoid such unexpected mistakes, it is possible that you want to protect yourself and lock yourself in that you don't want your subordinate or colleague to edit something.

Summary:

Follow these steps to lock cells in an exceedingly worksheet:

1. Choose the cells you wish to lock.

2. Within the Alignment group on the home tab, click the little arrow to open the Format Cells popup window.

3. On the Protection tab, select the barred check box, so click okay to shut the popup.

4. Within the ribbon on the Review tab, choose either protect Sheet or protect Workbook in the change group, so reapply protection.

Content or Highlights:

• How to Lock(Protect) Cells in Excel: Steps
• Let's Verify Whether Cells are Protected or Not
• What is Microsoft Excel?
• What is the lock and protection function in Excel?

How to Lock(Protect) Cells in Excel: Steps

Without further ado, let's start with our one-point agenda which is to lock or protect cells in Excel. Let's now return to practical mode and start our Microsoft Excel. We're in Microsoft Excel now, and this particular table relates to employee details taken as an example. Now let's imagine that this is our confidential data and you only want to edit two columns, namely, the label column and the phone number column. Now let's imagine the company has closed a year and now it's here some promotions that take place in the company and also imagine that the phone numbers of the employees provided by the company may have undergone some changes see all columns with blood type new raise current salary and employee name serial number employee number everything can be edited make some mistakes so you want to avoid it so you lock b cells let's rename this sheet now the sheet has been renamed successfully.

Now you can register the cells using the following process. So in this process, you have two main steps: 

(1) The first is to register the cells and 

(2) The next is to password protect the cells now when you select all the cells in this sheet, you can just click this frame here and you've selected all cells. 

Now right-click anywhere on the sheet and you can see an option called Format Cells and you want to go to the protection part so you can see that Excel is keeping all cells locked by default. Now we want the phone number and label to be properly unlocked. Now let's right-click and let's go to formatting the cells and in the protection option uncheck the icon or locked now choose ok and now good for you to combine the Can't insert cell we have a cell here that has been merged well let's delete that t good, now select the entire column again, right-click to enter the format cells and remove the tick from the lock option, select ok, now we have that Completed first part which locks all cells that you don't want to edit and unlocks the cells that you now want to do some editing. 

The second step is to protect the sheet, now you do right click on the sheet name and you can see an option called Protect Sheet, click on it and now you can select record cells here and also unlock cells so leave You to give us a password here, so we'll just use a password so we don't forget, so I'll pick one, two, three and now choose ok, re-enter the password to continue. Now we have successfully locked and protected all cells in Excel.

Let's Verify Whether Cells are Protected or Not:

Now let's check if the cells You wanted to protect are actually protected and locked or not, so we've unlocked the phone number and label and everything else is locked. Now let me try to edit the blood type so that when you double click or try to edit this particular sheet, I get a warning from Excel that the cell or chart you want to change is in a protected sheet, to make a change is blocked and you cannot edit it now. 

Let's try editing the phone numbers we left as unlocked so you can see that I can actually edit the unlocked cell here. Let me try to change this phone number. Let me put in a random number phone so you can see the cell is editable now, let's check the label column and try to edit that particular column, as I said, there is a promotion in the company so the deputy CEO is now the current CEO of the company and the software. The software developer also becomes the semi-software developer and tester, let's imagine he becomes the senior and so on, so this shows that this particular sheet can be worked on, not the whole Leaf, but only the sense that we have retained analogously. Well, so so lock and protect your cells in Excel. 

What is Microsoft Excel?  

Excel is one of the best applications on the market for creating spreadsheets, processing numbers and dashboard reports, and storing and managing data. This software first appeared in 1987 and has since become one of the most popular homes or business software.

What is the lock and protection function in Excel? 

The lock and protect feature in Excel helps users protect Excel worksheet cells that contain some important or sensitive data that should be protected from unwanted changes by other Excel worksheet users. Standard To protect them, you can protect your sheet with a password.

So we have reached the end of this tutorial on how to lock and protect in Excel, if you have any questions about any of the topics covered in this session, feel free to let us know in the comments section below and our team of experts will be happy to answer all your questions until next time. 

Thank you, stay safe, and keep learning.