How to Lock and Protect Cells in Excel (Lock and Unlock cells before you Protect your Spreadsheet)

LOCK AND PROTECT CELLS IN MICROSOFT EXCEL // Learn how to lock or unlock specific cells of a protected spreadsheet. Suppose you want to protect a spreadsheet but still be able to let other users enter data into certain cells. This video will demonstrate how to set cells as locked (unable to edit) or unlocked (editable) before you protect (lock-down) the spreadsheet.

✴ Lock cells to protect them
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.

LinkedIn: https://www.linkedin.com/in/sharonsmithhr

Twitter: https://twitter.com/SharonSmithHR
__________
RESOURCES:
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
__________
NOTE: Some links included here are affiliate links. If you click on these links and make a purchase, we may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #ExcelTutorials, lock cells in excel, protect cells in excel, how to lock and protect cells in excel, unlock cells in excel, protect formula in excel, Microsoft excel, Sharon Smith HR
__________
PLAYLISTS:
➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Quickies (Under 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Видео How to Lock and Protect Cells in Excel (Lock and Unlock cells before you Protect your Spreadsheet) канала Sharon Smith