» Protecting Cells Containing Formulas in an Unprotected Sheet
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Microsoft Office XP Introductory Concepts and Techniques
- Business Plans Kit for Dummies (With CD-ROM)
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Positioning: The Battle for Your Mind
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
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?
