For an individual spreadsheet, select Protect Sheet followed by Unprotect Sheet to remove password protections. For a workbook composed of multiple spreadsheets, select Protect Workbook followed ...

To remove password protection from Excel, you need to open the spreadsheet and go to the File > Info section. Then, click on the Protect Workbook option and select the Encrypt with password option ...

Protected and unprotected cells look the same in a spreadsheet. To delete all unprotected cells, you must select all of them at once, which can be easily done by using the Find and Replace feature.

Using Microsoft Excel 2007, you can protect worksheets in order to keep other users from making changes. Unfortunately, this protection applies to everything on the worksheet, including groups.