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 the sales data unlocked for editing, so people can 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 not modifiable). Watch this Excel video tutorial to learn how to do this.

Watch the following video tutorial:

How to freeze a row in Excel
https://www.youtube.com/watch?vyw_WsTSh9RE

How to protect/unprotect an Excel sheet
https://www.youtube.com/watch?v5S0DK50_yrg&listPLAE-5Y383viiXja3Haw6q3uf-aglWE3De

How to hide sheets in Excel
https://www.youtube.com/watch?vGZdvMARxwkc

️ Become a patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube https://www.youtube.com/@ExcelTutorialsEasyClickAcademy/join

️Timestamp️
0:00 How to lock cells in Excel
1:24 How to select editable cells in a locked worksheet
2:50 How to unlock cells in Excel

Subscribe and watch more videos that help you use Microsoft Excel quickly and easily
https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation1

Do you have Microsoft Office 365? Get it here
https://www.easyclickacademy.com/buy-microsoft-office/?utm_campaignHow%20to%20Lock%20Cells%20in%20Excel&utm_mediumYouTube&utm_sourcePopis

Transcription How to lock cells in Excel here
https://www.easyclickacademy.com/how-to-lock-cells-in-excel/?utm_campaignHow%20to%20Lock%20Cells%20in%20Excel&utm_mediumYouTube&utm_sourcePopis

Connect:
LinkedIn https://www.linkedin.com/company/easyclickacademy
Facebook https://www.facebook.com/EasyClickAcademy

Screen Recorder & Video Editor:
Camtasia https://techsmith.pxf.io/c/1266206/347799/5161?uhttps%3A%2F%2Fwww.techsmith.com%2Fvideo-editor.html

Voiceover artist https://seaantonyvo.com

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

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