How to Remove Passwords in Excel 2007

By Peter Thomas

Microsoft Excel 2007 is a spreadsheet application that allows you to keep track of financial information and spreadsheet data. It supports formulas that allow fields of the sheet to update dynamically and perform advanced calculations. Once a sensitive Excel document is created, it can be saved with a password to prevent further modification to the document. Password-protected Excel files cannot be modified without first removing their password by using the "Unprotect Sheet" option included in Excel. Once the password is removed, the document can be modified freely.

Step 1

Open the password-protected Excel 2007 file by double-clicking it from Windows or clicking "Open" from the Office menu at the upper left of the screen.

Step 2

Attempt to modify the document by double-clicking a cell and attempting to change a value. An error message will appear and warn you about your attempted action.

Step 3

Click the "Review" tab at the top of the screen.

Step 4

Click "Unprotect Sheet" and supply the document's password when prompted. Click "OK" to submit the password.

Step 5

Click the Office icon and then click "Save." The document will be saved in its unprotected state, and a password will no longer be needed to modify it.