Deleting Everything Except Formulas

Let's face it--when it comes to developing worksheets, we spend most of our time creating formulas. It seems, then, a waste to throw out perfectly good formulas and recreate a worksheet from scratch just because you need to get rid of a bunch of values in the worksheet. There may be an easier way--just get rid of everything except the formulas. Follow these steps:

1. Display the worksheet you want to edit.
2. Press F5 to display the Go To dialog box.
3. Click Special. Excel displays the Go To Special dialog box. (Click here to see a related figure.)
4. Make sure the Constants option button is selected. The check boxes below Formulas should then become accessible.
5. Using the four checkboxes under Formulas, specify what type of constants you want to select.
6. Click OK. Excel selects all the cells that meet your criteria.
7. Press Delete. The contents of the selected cells are deleted.