|  

» Protecting Cells Containing Formulas in an Unprotected Sheet

To protect cells containing Formulas in an unprotected sheet, use Validation:

Step 1: Selecting cells containing formulas:

1. Press F5.
2. Click Special, and then select the Formulas option.
3. Click OK.

Step 2: Validation:

1. From the Data menu, select Validation.
2. Select the Settings tab, and select Custom from the Allow dropdown list.
3. In the Formula box, type ="", and then click OK.
Screenshot // Protecting Cells Containing Formulas in an Unprotected Sheet
Protecting Cells Containing Formulas in an Unprotected Sheet


Rate This Tip
12 34 5
Rating: 3.23     Views: 32903
protect cells containing formulas
macdonpn
I tried your method in excel 2000 sp3 and it does not work.
Protecting cells
RayC
I tried it in the first it works because I edit the contents but its not working when I delete the content of the cell. I thought its protected but why I can delete it?
Click here to post comment
For Registered Users
Name
Comment Title
Comments