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
► https://www.youtube.com/watch?v=yw_WsTSh9RE

How to Protect / Unprotect Excel Sheet
► https://www.youtube.com/watch?v=5S0DK50_yrg&list=PLAE-5Y383viiXja3Haw6q3uf-aglWE3De

How to Hide Sheets in Excel
► https://www.youtube.com/watch?v=GZdvMARxwkc

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

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

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

️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
► https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1

Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy-microsoft-office/?utm_campaign=How%20to%20Lock%20Cells%20in%20Excel&utm_medium=YouTube&utm_source=Popis

Transcription How to Lock Cells in Excel here
► https://www.easyclickacademy.com/how-to-lock-cells-in-excel/?utm_campaign=How%20to%20Lock%20Cells%20in%20Excel&utm_medium=YouTube&utm_source=Popis

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?u=https%3A%2F%2Fwww.techsmith.com%2Fvideo-editor.html

Voice over artist ► https://seanantonyvo.com

#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy

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