How To Password Protect Workbook | Microsoft Excel 2016 Tutorial | The Teacher

How To Password Protect Workbook | Microsoft Excel 2016 Tutorial | The Teacher


To password protect your Microsoft Excel Worksheet,
click on File Menu, and choose Save. Choose the location where you want to save your Excel
Worksheet, and type a name. Click Tools, and then click General Options. Here you can specify
two different passwords for your Worksheet, first to open Worksheet, and second for modification.
Password to Modify option is useful, if you want your colleague to be able to open the
Worksheet, but he shouldn’t make any changes, then you can tell him only the first password
to open the Worksheet. He may still be able to make changes to Worksheet,
without entering the modification password, by clicking on Read Only button. But while
saving the Worksheet, he has to save the Worksheet with a different name. The original password
protected Worksheet will remain intact. If you do not wish to assign Modification
Password, but want to warn the editor, that he should only modify the Worksheet in Read
Only mode, unless necessary, then while protecting your Worksheet with a open password alone,
you can make a check mark on Read Only Recommended. This option will display a warning message
and will ask the user, if he wants to open the Worksheet as read only, or he is sure
about full access, and want to modify the Worksheet. So, this was all about protecting your Excel
Worksheet with passwords. Hope you may have liked this video. Don’t forget to hit the
like button, and do subscribe to our channel for more upcoming videos. Thanks for watching,
and have a nice day!

4 Replies to “How To Password Protect Workbook | Microsoft Excel 2016 Tutorial | The Teacher”

Leave a Reply

Your email address will not be published. Required fields are marked *