7 Ways To Protect an Excel Workbook From Editing | Advanced
124,286
Published 2020-04-20
Protecting an Excel workbook is an invaluable time saver when sharing your Excel files with other people. You've all probably experienced unwanted edits to your formulas or the formatting in your excel workbooks. Learning to protect your work from edits can be an invaluable tool. What most people don't know is that it goes beyond just pushing "protect worksheet". In this video I'll teach you to:
• Protect a workbook
• Protect a worksheet
• Password Protect a workbook/worksheet
• Hide columns and sheets from view
• Protect an Excel sheet, but still allow some edits
• Protect the integrity of your data collection (using dropdowns)
• Make a workbook "read only"
• BONUS: Encrypt a workbook (you can only open with a password).
Here are some other videos you Might like:
• Excel Conditional Formatting: • Excel Conditional Formatting Formula ...
• Excel COUNTIFS | Multiple Criteria | Greater than or Less Than: • Excel COUNTIF | Multiple Criteria | G...
• IF Formula in Excel: • IF Formula in Excel | 2020
Thanks again for watching. If you found this video useful, please consider supporting my channel by subscribing, and sharing my content. Doing both will get it out there for more folks to learn from.
All Comments (21)
-
Clear helpful instructions, still relevant in 2024. Thanks!
-
fantastic overview! thank you! exactly what i was looking for!
-
Very helpful and easy to follow. Thank you!
-
Really useful advice! Thanks!
-
wow i really like tour videos. i am learning a lot at home, i have never did computer lesson but through you, you made my life soo easier thank you. All the way from Namibia
-
Nice! Thank you for all the information
-
Thank you. Great info!
-
Great one, I’ve really grabbed alot
-
So helpful, thank you!
-
Simple ...Simple....Simple...Simple.... Keep doing your videos
-
Thank You. This help me out so much :)
-
super helpful, thanks!
-
clear instructions, easy to follow, Great!!!
-
Well done! Thanks
-
Thank you. You taught me how to protect my workbook,
-
Well done. No nonsense. Thank you.
-
very usefull! Thank you.
-
its really helpful
-
Very helpful 😊
-
Subscribed. Great video.