How to Protect an Excel Sheet with a Password

If you are sharing a spreadsheet that contains sensitive financial data, employee records, or complex proprietary formulas, the last thing you want is for someone to accidentally delete a cell or intentionally modify a number. Microsoft Excel offers several layers of security. You can either lock specific cells from being edited, or you can lock the entire file so no one can even open it without a password.

How to Password Protect an Entire Excel File

If the data is strictly confidential and you do not want unauthorized people even looking at the document, use this method. Anyone attempting to open the file will be greeted with a blank screen and a password prompt.

1. Open the Excel workbook you want to protect.
2. Click on File in the top-left corner of the ribbon.
3. Select Info from the left-hand menu.
4. Click on the large square button that says Protect Workbook.
5. From the drop-down menu, select Encrypt with Password.
6. A small box will appear. Type your desired password and click OK.
7. Excel will ask you to re-enter the password to confirm. Type it again and click OK.
8. Save the file.

Warning: Microsoft cannot recover forgotten Excel passwords. If you lose this password, you will permanently lose access to the file. Write it down in a secure password manager!

How to Protect a Sheet from Editing (Read-Only)

If you want people to be able to open and read the spreadsheet, but you want to prevent them from changing any of the numbers or deleting rows, you should protect the sheet itself.

1. Open the Excel workbook and click on the specific sheet tab at the bottom that you want to lock.
2. Click on the Review tab in the top ribbon menu.
3. Click on Protect Sheet.
4. A dialog box will appear. Check the box at the top that says Protect worksheet and contents of locked cells.
5. Below that, enter a password in the text box.
6. In the list below, you can choose exactly what users are allowed to do. For maximum security, leave only the top two boxes checked (“Select locked cells” and “Select unlocked cells”). This allows them to click around but not edit.
7. Click OK, re-enter the password to confirm, and click OK again.

Now, if anyone tries to type into a cell, Excel will pop up an error message stating that the sheet is protected.

How to Remove the Password Protection

If you need to make edits or remove the security entirely:

• To unprotect a file: Go to File > Info > Protect Workbook > Encrypt with Password. Delete the dots in the password box so it is entirely blank, and click OK.
• To unprotect a sheet: Go to the Review tab and click Unprotect Sheet. You will be prompted to enter the password.

Conclusion

Applying passwords to your Excel files ensures that your hard work and complex formulas remain intact, preventing accidental keystrokes from ruining important business data.