How to Remove Password Protection in Excel

By Anthony Smith

Microsoft Excel spreadsheet software can be a powerful tool for its users--as long as they are familiar with the use of at least some of its many features. One feature that is particularly useful is the password protection offered by the program. Users can protect specified areas of a spreadsheet, or an entire workbook from any unauthorized or accidental changes. Of course, it is important to know how to remove the password protection so that the file can be edited.

Step 1

Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5.

Step 2

Click on the "File" menu, and then select "Save As." Click on the "Tools" menu and select "General Options."

Step 3

Double-click on the asterisk that is in the "Password to open" box, and then press "DELETE" on your keyboard. DO the same for the box labeled "Password to modify."

Step 4

Click on "OK," then "Save," and finally "Yes" to complete the password protection removal if your are using Excel 2003 or earlier.

Step 5

Click on the "Review" tab at the top of the Excel 2007 window, and locate the group of icons within the "Changes" group. Click on "Unprotect Sheet." Type in the appropriate password when and if you are prompted, and you are finished.