Sunday, May 19, 2024
HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: How to Clear the Values while Keeping Formulas

Excel 2007: How to Clear the Values while Keeping Formulas

If you are constantly using a spreadsheet that requires you clear the values but retain the formulas, it can be painful to go through and select each field individually for deletion. Excel makes it easy to do this in just a few steps.

1. Open the Excel worksheet containing the values and formulas.

2. Press Ctrl+G to bring up the Go To dialog box.

3. Click the Special button in the bottom-left corner of the box.

4. In the Go To Special dialog box, select the Constants radio button. Now check the Numbers checkbox underneath Formulas. Make sure that the Text, Logicals, and Errors checkboxes are unchecked.

5. Click the OK button.

6. All fields containing values and not formulas will be highlighted. Press the Delete key on your keyboard to clear out the values.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!