How To Password Protect Microsoft Excel 2016 Worksheets

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.

No comments:

Post a Comment