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.