How to Lock, Unlock all or specific Cells in Excel. (Including Hiding Excel Formulas)

Published: 18 May 2021
on channel: Excel Sirji
4,223
23

This video covers that how you can protect and unprotect cells. How you can allow user to navigate only in specific excel area by locking and unlocking Cells. And at the end you will learn how to display and hide excel formulas before sharing with your colleagues.

Lets watch this video to learn more about lock and unlocking cells. Below are the time stamps:

00:00 How to lock and unlock Cells
01:17 How to protect all the cells in Excel Sheet
03:15 How to allow user to edit only specific cells in Excel
05:02 Activating limited area for navigation in Excel
06:18 How to Hide/Unhide the Formulas in Excel Cell

So while protecting the sheet, it basically asks to select locked cell or unlocked cell, you can choose option as per your requirement. To change the cell lock property in excel, you need to right click on cell or excel range then select format cells, go to protection and check or uncheck locked cell option for allowing editing particular cells. Also you can check uncheck to hide formulas from formula bar in Excel

Few more videos which may help you to learn more about other Excel Function:

Excel SUMIF Function:    • How to use Excel SUMIF and SUMIFS Fun...  ​
Index and Match:    • Excel Index and Match Function - Comp...  ​
Excel Offset Function:   • Excel Offset Function - Advanced Dash...  ​
Indirect Excel Function:    • Excel INDIRECT Function _Free Excel A...  ​
Pivot Tables:    • Pivot Tables in Excel - Complete Guide  ​

You can also navigate for more training resources on our website https://www.excelsirji.com​​​​

If you wanna support us and want us to create more about Excel. You can buy us a coffee from here:
https://www.buymeacoffee.com/excelsirji

Follow us to get new updates

#MsExcel #Protectsheet #lockcells


Watch video How to Lock, Unlock all or specific Cells in Excel. (Including Hiding Excel Formulas) online without registration, duration hours minute second in high quality. This video was added by user Excel Sirji 18 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,223 once and liked it 23 people.