How to Lock Cells in Excel

In this short video tutorial, I’ll show you how to lock cells in an Excel spreadsheet to protect them from overwriting. What we want to do here is leave the cells containing sales data unlocked for editing, so that people could write their own values in these cells, but, at the same time, lock the cells with formulas, months and names to make them read-only (or non-editable). Watch this excel video tutorial to learn how to do it.

Watch next video tutorial:

How to Freeze a Row in Excel

How to Protect / Unprotect Excel Sheet

How to Hide Sheets in Excel

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 How to Lock Cells in Excel
1:24 How to Select Editable Cells in Locked Spreadsheet
2:50 How to Unlock Cells in Excel

================

Subscribe and watch more videos that help you use Microsoft Excel quick and easy

Got Microsoft Office 365? Get it here

Transcription How to Lock Cells in Excel here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

[deoarby]

I read several instructions and watched a couple of other videos. They were clear as mud. This vid just lays it out without having you jump all over the place.

[susmitashinde]

Woah! The concept of locking & unlocking of the cells was such a blur for me. This video helped me clear that out. It had become a road blocker for me in one of the project. Thanks a lot!!! :)

[aryanfakoor]

Oh my god, finally found the solution to moving through open fields while not chaning the locked ones. This was amazingly helpful. Thank you.

[HelenMartinez]

SUCH a helpful, simple, and clear tutorial. Thank you for showing me what I wanted to do in an exact manner without password protection!

[nerdybunny]

Appreciate for keeping the video a straightforward simple one.

[markbozarth-dreher]

I love a good, short, to the point and effective tutorial. Thanks y'all!

[johnskorupa]

I searched other places but yours was the best explanation on how to lock specific cells. Thank you so much!!!

[johnk]

Out Freaking Standing, I totally forgot how to do this and you brought back everything. Great Video.

[zestpayrollsolutions]

Thank you so much for this! Such a straight forward and easy to follow tutorial and it's saved me SO much time trying (and failing!) to sort it myself.

[theCapitalChief]

THANKS PAL! I FELL LIKE I JUST WON A CHAMPIONSHIP WITH THIS ONE! I'm not kidding!

[danieliskander]

Hi. I very much liked your simple explanation. This is the third video that I have watched on the same subject. The first two almost got me thinking of taking a long course on Excel. They made it look so hard... almost impossible. I watched the previous videos several times. This one, only once, and here I am ... locking and unlocking cells as I choose to. Thank you, a million times.

[cathyjae]

Thank You so much. Actually, I watched some video tutorial but this one is amazing.

[jeanettesefers]

Great tutorial. Super helpful. Initially I didn't do the "magic" step - the Protect Sheet, and was a little confused. BUT, patience paid off. Thank you for sharing.

[stevedelossantos]

Thank you for this very quick and easy steps. It is easy to follow.

[mgfnkex]

I must appreciate you bro, you have explained in super easiest way. done it.

[ScarletSerenade]

I was banging my head against my keyboard, trying to figure out what I was doing wrong. You made it so easy and stress-free. Thanks! :)

[TM-zbug]

Thank you for this awesome video about locking and unlocking cells. I was going bonkers looking at other videos that made it so complicated! This was easy to understand and I enjoyed the way you presented the material!

[danvirramesar]

Sweet, simple, and to the point. Thank you!

[AnmolKumar-wdrv]

Thnak You so much, I was watching a 10 hrs excel course video and he was explaining everything very well but when he came to "lock cells & protect sheet" I was not abnl;e to understand that part from his video so I serached for this topic separately. I understoood very well from your video. Thanks bro. 🙏❤❤

[owampairemacklyne]

Thanks. Short and precise but very helpful❤