how to make excel read only with password

You can also click “Read-only recommended” if you would like to have the document suggest it be opened in read-only mode (this is not required). As previously stated, we recommend using both. You will now see a pop up with sections for a password to open the file and a password to modify the file. To do this, click File and a dropdown will pop up, select “Passwords”. Once we have some information in the sheet, we want to password protect the document. You can always customize this to better fit your needs, by adding notes or links to sites.

For our purposes the main information we want to capture is the login website, username and password. For the most part these steps are the same.įirst open Excel and format the document the way you want. The following will be some steps to password protect an Excel document on a Mac with Microsoft Office 2011, and then we will post the Windows Microsoft 2013 steps. The more you protect this document, the better off you are.

If this document will be used by more than one person, we recommend tracking changes so you can tell when a password and/or login is changed. There are a few different options for password protection, you can password protect the document for viewing, editing, and/or track changes. Once you create your Excel spreadsheet with your logins and passwords, we HIGHLY recommend password protecting the document.

How to make excel read only with password