7 Ways To Protect an Excel Workbook From Editing | Advanced
121,222
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!
-
Nice! Thank you for all the information
-
Thank you. Great info!
-
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
-
So helpful, thank you!
-
Great one, I’ve really grabbed alot
-
Thank You. This help me out so much :)
-
clear instructions, easy to follow, Great!!!
-
Well done. No nonsense. Thank you.
-
super helpful, thanks!
-
Very useful. Thank you!
-
Well done! Thanks
-
Great video. Can you discuss Protect Structure &. all the other Protect Workbook options in the Backstage view?
-
Thank you. You taught me how to protect my workbook,
-
Thanks man u helped alot!!! apparently working and studying excel is totally different and im trying to learn more
-
Simple ...Simple....Simple...Simple.... Keep doing your videos
-
very usefull! Thank you.