CATEGORY: Excel Editing VERSIONS: Microsoft Excel 2007

To protect cells containing Formulas in an unprotected sheet, use Data Validation: Step 1: Selecting cells containing formulas: Select Home - Find & Select (in Editing Group) - Formulas. Or 1. Press F5. 2. Click Special, and then select the Formulas option. 3. Click OK. Step 2: Data Validation: 1. Select Data - Data Validation (in Data Tools Group). 2. Select the Settings tab, and select Custom from the Allow dropdown list. 3. To protect formulas type in the Formula box ="", and then click OK.

Screenshot // Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007

Rate this tip 1 2 3 4 5   RATING: 1.00   VIEWS: 1439 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Business Plans Kit for Dummies (With CD-ROM) Marketing Planning for Services Financial Modeling - 2nd Edition Microsoft Windows XP Registry Guide Windows XP for Dummies Excel 2002 Power Programming with VBA

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books