Excel 2007: How to Clear the Values while Keeping Formulas

Posted August 12, 2008 by Rob Rogers in Microsoft Excel

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.

 

About Rob Rogers

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

The Conversation

Follow the reactions below and share your own thoughts.

  • Anonymous

    HOW WE CONVERT ONLY VLOOKUP FORMULA WITH VALUE IN A WORKSHEET?

  • Anonymous

    Very good post

  • Abhinav

    Really good Post..helped me a lot..