» Protecting Cells Containing Formulas in an Unprotected Sheet
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Special Edition Using Microsoft Excel 2002
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Analysis of Financial Statements
- Marketing Plans
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
