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 readonly (or noneditable). Watch this excel video tutorial to learn how to do it.
Watch next video tutorial:
How to Freeze a Row in Excel
► • How to Freeze Top Row and First Colum...
How to Protect / Unprotect Excel Sheet
► • How to Protect Excel Sheet with Password
How to Hide Sheets in Excel
► • How to Hide Sheets in Excel
================
❤ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube ► https://www.youtube.com/@ExcelTutoria...
================
⏱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/ExcelTutori...
Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy...
Transcription How to Lock Cells in Excel here
► https://www.easyclickacademy.com/how...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► https://techsmith.pxf.io/c/1266206/34...
Voice over artist ► https://seanantonyvo.com
#MicrosoftExcel #ExcelQuickAndEasy #EasyClickAcademy