How to LOCK CELLS in Excel for FREE to Protect Your Data & Formulas –Also UNLOCK a Range of cells

Опубликовано: 17 Октябрь 2024
на канале: Digestible Ms Office Tutorials & Apps
102
23

You have a data in your excel sheet that you spent days or month posting your data only to come back to a total mess?
Working on spreadsheets that are shared might be a nuisance. This, however, does not have to be the case!
In this video, I'll teach 2 methods on how you can protect your work by LOCKING and UNLOCKING any cell, or a group of cells. You'll be able to SAFEGUARD YOUR FORMULA CELLS and only allow individuals to enter data in SPECIFIED RANGES/ CELLS. I'll also teach an awesome trick on how you can use Excel to MULTI-SELECT cells depending on their COLOUR at once and unlock them.
That’s all I have in this video.
If you learned something valuable, kindly give this video a thumbs up.
🔔 Subscribe to my YouTube channel for more step by step tutorials    / @digestiblemsofficetutorial9987  

🎬 Click Here to watch my Latest Video    • How to Add a Watermark in Word for Pr...