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:
How to Lock Cell Based on Date in Excel: • How to Lock Cell Based on Date in Excel
How To Lock and Protect Formulas in Excel: • How To Lock And Protect Formulas In E...
How to Hide Formula in Excel: • How to Hide Formula In Excel
How To Lock or Protect Cells After Data Entry or Input in Excel: • How To Lock Or Protect Cells After Da...
How To Lock Screen to Prevent Scrolling in Excel Worksheet: • How To Lock Screen To Prevent Scrolli...
How to Lock Scroll Area in Excel with VBA: • How to Lock Scroll Area in Excel with...
How to Lock Rows Based on Date in Excel Except Empty Rows: • How to Lock Rows Based on Date in Exc...
How to Lock Column Based on Date in Microsoft Excel: • How to Lock Column Based on Date in M...
How to Lock Column After Each Day in Microsoft Excel: • How to Lock Column After Each Day in ...
How To Protect or Lock Workbook Structure in Excel: • How To Protect or Lock Workbook Struc...
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:
How To Toggle or Turn On/Off Worksheet Protection in Excel: • How To Toggle Or Turn On/Off Workshee...
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
/ excel10tutorial
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG