To remove protection from the spreadsheet, open it in Excel, click the "Review" tab and then click "Unprotect Sheet" in the Changes group. Type the password into the Password field and click "OK." ...

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.

Excel 2007 uses a password-protection system that converts your spreadsheet to a read-only format, hides the spreadsheet's formulas and allows only selected cells to be modified.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...