How To Lock Cells | How To Lock Some Specific Cells In Excel

Показать описание

Learn: The Quick & easy way on How To Lock Cells | How To Lock Some Specific Cells In Excel

In this video, you will learn:

1. How To Lock Cells
2. How To Lock Some Specific Cells In Excel

Before we learn how to lock cells in Excel, we need to understand how it works on a conceptual level.
All cells in Excel are locked by default.
But…
It doesn’t work until you also protect these cells.
Only when you have a combination of cells that are locked and protected, then you can truly prevent people from making changes.
In this video tutorial, you’ll learn:
• How to lock all the cells in a worksheet in Excel.
• How to lock some specific cells in Excel.
So, let’s get started.

HOW TO LOCK ALL THE CELLS IN A WORKSHEET IN EXCEL

This essentially means that you want to lock the entire worksheet.
Now, since we already know that all the cells are locked by default, all we need to do is to protect the entire worksheet.
Here are the steps to lock all the cells in a worksheet.
• Click the Review tab.
• In the Changes group, click on Protect Sheet.
• In the Protect Sheet dialog box:
• Make sure that you’ve checked the box ‘Protect worksheet and contents of locked cells’ (it’s checked by default).
• Enter a password (if you want to password protect the sheet).
• Specify what a user is allowed to do. By default, the first two boxes are checked that allow a user to select locked and unlocked cells. You can allow other options as well such as formatting or inserting rows/columns.
• Click OK.

If you have used a password, it will ask you to reconfirm the password.
Once locked, you’ll notice that most of the options in the ribbon are unavailable, and if someone tries to change anything in the worksheet, it shows a prompt as The cell or chat you are trying to change is on a protected worksheet
To unlock the worksheet, go to Review, Protect Sheet. If you had used a password to lock the worksheet, it will ask you to enter that password to unlock it.

LOCK SOME SPECIFIC CELLS IN EXCEL

Sometimes, you may want to lock some specific cells that contain crucial data points or formulas.
In this case, you need to simply protect the cells that you want to lock and leave the rest as it is.

Now, since all the cells are locked by default, if you protect the sheet, all the cells would get locked. Hence you need to first make sure only the cells that you want to protect are locked, and then protect the worksheet.
Here is a simple example where I want to lock data from WEEK 1 TO WEEK 4 because these contain values that are not to be changed.
Here are the steps to lock these cells:
• Select the entire sheet and click on the dialog box launcher in the Alignment group in the Home tab (you can also use the keyboard shortcut Control + 1).
• In the Format Cells dialog box, in the Protection tab, uncheck the box for Locked.
• Click OK.
• Now, Select the cells that you want to lock (in this case, I will select WEEK 1 TO WEEK 4).
• Again, click on the dialog box launcher in the Alignment group within the Home tab (or use the keyboard shortcut Control + 1).
• In the Format Cells dialog box, in the Protection tab, check the box for Locked. The steps so far would unlock all the cells in the worksheet except the ones that you want to lock i.e. (WEEK 1 TO WEEK 4 in this case). Then,
• Go to the Review tab.
• In the Changes group, click on Protect Sheet.
• In the Protect Sheet dialog box:
• Make sure you’ve checked the box ‘Protect worksheet and contents of locked cells’ (it’s checked by default).
• Enter a password (if you want to password protect the sheet).
• Specify what all a user is allowed to do. By default, the first two boxes are checked that allow a user to select locked and unlocked cells. You can allow other options as well such as formatting or inserting rows/columns.
• Click OK.

If you have used a password, it will ask you to reconfirm the password.

……………………………………………………………………………………………………………………….

For more simple and easy to follow How-to videos,

Click the Link Below to subscribe:

Join this channel to get access to perks:

#Exceldatabase #Daverage #ExcelVlookup #Daverageerror

LearnexcelwithT