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:
__________
CONNECT WITH ME:

__________
RESOURCES:
__________
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:

[francesdobbins]

I really liked your video. It's easy to follow and understand.

[azurenf]

Thank you for the video. Quick question - what is the purpose of the password with this setting (i.e., what is the advantage of using the password vs. not using it)?

[gilbertcuriel]

How can I lock cells in cloud based Excel? It doesn't seem to be possible.

[mundoaztek]

It seems like this video is outdated since it doesn't give the options to format the cell as it shows in her video. (06/23/2021)