DonnaYoung.org

How to Unprotect and Protect a Sheet

How do I unprotect a worksheet so I can make changes?

The worksheets that can be unprotected are the ones shown in white:

Unprotect Sheet
Tools > Protection > Unprotect Sheet.

Protect Sheet by doing the same.
Tools > Protection > Protect Sheet.

This window will appear:

Leave the password field blank unless you just want to password protect it. If you do password protect it, be certain to remember the password.