How to password protect workbook in Excel Mac 2011

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list.

201109292051.jpg

This would display the following File Passwords window with different password option.

201109292054.jpg

You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.


Comments

  1. I import financial data from my bank into my Excel 2011 spreadsheet on my Mac Os 10.11.6 and all works well. I want to send the file to my bookkeeper and want to Password Protect it, however when I go through the regular sequence File / Passwords / ….The File Password box is greyed back–I cannot set a password.
    Any assistance is appreciated.
    Thanks

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.