Unprotect Selected Cells

When using security in an excel workbook, or just creating a simple template, the need arises to protect the worksheet, but unprotect the cells you would like to allow data manipulation. Here’s how.

Before the worksheet is protected:

1. Right-click the selected cells

2. Choose Format Cells

3. Click the “Protection” tab

4. Make sure the checkbox next to “Locked” does not have a checkmark in it and hit OK

5. Protect your worksheet now, and your previously selected cells will be unprotected, but the rest of the sheet is protected.

Leave a Comment