How to Unlock Excel 2007 Password Protection

Unlock Document Password
1. Open the Excel file in Excel 2007. You will need to enter the correct password to open the file.
2. Click on the Microsoft Office Button, located in the upper right corner of the Excel 2007 program. Move your mouse over 'Prepare' on the left hand side of the window. Choose 'Encrypt Document' from the list of options on the right.
3. Place your cursor to the right of the password in the box. Use the backspace key to erase the password. Click 'OK' when you are done. The Excel 2007 document is no longer password protected.
Unlock Worksheet Password
4. Open the Excel 2007 file that you need to work on. If needed, select the correct locked worksheet from the list of sheets at the bottom of the Excel document.
5. Select the 'Review' tab at the top of the screen.
6. Locate the 'Change' area and click on either 'Unprotect Sheet' or 'Unprotect Workbook.'
7. Type in your password into the pop-up window. Click 'OK' when you are done. The worksheet, or workbook, is no longer protected.