How to Remove Passwords in Excel 2007

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

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

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

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

Step

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

Step

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.