How To Lock Cells in Microsoft Excel

How To Lock Cells in Microsoft Excel
In this intermediate excel tutorial, I’ll explain an easy yet crucial feature of excel. I’ll be talking about locking certain cells in excel using protect sheet feature. I’ll show you how you can lock certain cells from editing keeping other cells unlocked or editable.
It doesn’t matter if you want to lock single cell, multiple cells, adjacent cells or even distant cells. It’s all about selection. You can select specific cells that you want to lock and then follow the procedure and excel will lock those cells and protect the sheet.
You can even password protect the sheet or even use basic protection without any password. You can do that easily. I’ve covered a lot of tutorials about locking and unlocking cells. Please check the links for details:
Now I’m sure you know a lot about locking cells in excel. Let’s follow the procedure below to learn how to lock cells.
Step 1: Select the entire worksheet by Pressing CTRL+A.
Step 2: Right click an select format cell.
Step 3: Select Protection and make sure locked checkbox is marked.
Step 4: Now select all those cells you need to keep unlocked.
Step 5: Right click an select format cell.
Step 6: Select Protection and make sure locked checkbox is Unmarked
Step 7: Click on the “Review Tab” and select Protect Sheet.
Step 8: Enter password twice and click ok if you want to password protect cells. Or you can click ok for without password option.
Done. Now if you can edit or delete only specific cells and the rest of the cells are now locked. This is how you tell excel to lock cells.
Bonus Trick: Every time you need to unlock cells you need to click on the review tab and then click on unprotect sheet and then write the password to unlock cells but I’ve showed a different way in another tutorial. That will give you a custom keyboard shortcut and you’ll be able to lock and unlock cells by pressing that keyboard shortcut. Here is the link:
Hope you enjoy it. Thanks for reading. How you learned how to lock individual cells and protect sheets in excel.
#LockCells #PasswordProtect #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[pirusficus]

Perfectly explain, direct to the point, thank you very much.

[godwinuche]

Can you please be dropping a file link of any tutorial you are making so we can easily download the file to our own spreadsheet and follow the same process just like you explaining. Please kindly look into this