Unprotecting Cells

  1. Click the sheet for which you want to cancel the protection.

  2. Select Tools - Protect Sheet or Tools - Protect Spreadsheet to remove the check mark indicating the protected status.

  3. If you have assigned a password, enter it in this dialog and click OK.

The cells can now be edited, the formulas can be viewed, and all cells can be printed until you reactivate the protection for the sheet or document.