How to Unprotect a Spreadsheet in Office 2007

Microsoft Office 2007 can protect an Excel spreadsheet from unauthorized changes. The “Review” tab on the command Ribbon includes a “Protect Sheet” button to restrict editing. You can opt to enter a password to allow users to unprotect the sheet. Clicking the “Unprotect Sheet” button releases the Excel spreadsheet for editing.

...
Excel 2007 includes an "Unprotect Sheet" command to allow editing.

Step

Click on the “Review” tab on the command Ribbon.

Step

Click on the “Unprotect Sheet” button on the “Changes” group. The spreadsheet will be available for editing. If the spreadsheet is password protected, a dialog box entitled “Unprotect Sheet” will open.

Step

Enter the password, if applicable. Click on the “OK” button.