Excel 2007: How to Clear the Values while Keeping Formulas

Printer Friendly
Text Size: A A A A
image description
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.

    Excel

  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.

    Excel

  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.

This Tech Tip is brought to you by the Business and Technology Section ... IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here.

Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to communications@ficpa.org.

LAST UPDATED 9/2/2009