Here's a nifty way to delete all values entered into a workbook while keeping the formulas.

• Open the Excel worksheet containing the values and formulas.
• Hit "Ctrl G", that will bring up the Go To dialog box

• Click on "Special"
• Then select "Constants". Now check the "Numbers" checkbox underneath "Formulas". Make sure that the Text, Logicals, and Errors checkboxes are unchecked.
• Click OK

Read More ...