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: https://youtu.be/6etOvTOVThQ
How To Lock and Protect Formulas in Excel: https://youtu.be/yQjosXMTJyI
How to Hide Formula in Excel: https://youtu.be/pN9yA6gvWzw
How To Lock or Protect Cells After Data Entry or Input in Excel: https://youtu.be/vg8gZ_mbiaI
How To Lock Screen to Prevent Scrolling in Excel Worksheet: https://youtu.be/AqFgpUBG36w
How to Lock Scroll Area in Excel with VBA: https://youtu.be/ZfwEbjGIeeg
How to Lock Rows Based on Date in Excel Except Empty Rows: https://youtu.be/nGTndx8B0ms
How to Lock Column Based on Date in Microsoft Excel: https://youtu.be/BMjz0qPsoUs
How to Lock Column After Each Day in Microsoft Excel: https://youtu.be/2xyFRij0Zik
How To Protect or Lock Workbook Structure in Excel: https://youtu.be/TSyLPxD5AMk
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: https://youtu.be/NwQFBIGb50A
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
https://www.patreon.com/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: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Please take the opportunity to connect and share this video with your friends and family if you find it useful.