» 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:
- Investing for Dummies, Third Edition
- Seven Habits Of Highly Effective People
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Business Analysis with Microsoft Excel (2nd Edition)
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
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?
