Excel 2007: How to Clear the Values while Keeping Formulas
Contributed by Rob Rogers 
Tagged: 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.
You may also like -
OpenOffice.org Calc: Show Formulas to Verify Your Equations
Excel 2007: Show Formulas to Verify Your Equations
Excel 2007: Use the Watch Window to Monitor Cells
Excel 2007: Have Your Data Read Back To You
Excel 2007: Clear All Formatting From a Range of Cells
Microsoft Excel: How to Hide Tabs
Excel 2007: Eliminate Blank Rows in a Spreadsheet
Excel 2007: Where Did They Hide My Favorite Commands?
Anonymous said on December 11, 2009
HOW WE CONVERT ONLY VLOOKUP FORMULA WITH VALUE IN A WORKSHEET?
Anonymous said on March 11, 2010
Very good post
Abhinav said on January 31, 2012
Really good Post..helped me a lot..