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 dialogue and click OK.

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