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 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
Watch video How to Lock Cells in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Tutorials by EasyClick Academy 27 March 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,404,263 once and liked it 14 thousand people.