» Protecting Cells Containing Formulas in a Protected Sheet

To protect cells containing Formulas, two conditions must be met:

The cell must be locked:
1. Select a cell in the sheet and press Ctrl+1.
2. In the Format Cells dialog box, select the Protection tab.
3. Select the Locked option.

The sheet must be protected:
1. From the Tools menu, select Protection and then Protect Sheet.
2. Click OK.

Protecting cells containing Formulas, requires isolating the cells containing the Formulas from the rest of the cells in the sheet, locking them, and then protecting the sheet.

Step 1: Cancel the locked format of all the cells in the sheet:
1. Select all cells in the sheet by pressing Ctrl+A.
2. Press Ctrl+1.
3. Select the Protection tab, and deselect the Locked option.
4. Click OK.

Step 2: Selecting cells containing Formulas:
1. Press F5.
2. Click Special, and then select the Formulas option.
3. Click OK.

Step 3: Locking cells containing Formulas:
1. Press Ctrl+1.
2. Select the Protection tab, and then select the Locked option.
3. Click OK.

Step 4: Protecting the sheet:
1. From the Tools menu, select Protection, and then Protect Sheet.
2. Click OK (a password is optional).
Screenshot // Protecting Cells Containing Formulas in a Protected Sheet