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
All fields containing values and not formulas will be highlighted. Just press "Delete" and all values will be deleted, but will leave the formulas.
Recent comments
4 weeks 4 days ago
7 weeks 8 hours ago
7 weeks 8 hours ago
7 weeks 18 hours ago
7 weeks 5 days ago
7 weeks 5 days ago
9 weeks 1 day ago
9 weeks 2 days ago
12 weeks 3 days ago
1 year 23 weeks ago