Microsoft Excel 2007: Clearing Everything Except Formulas

Need to get rid of everything in a worksheet except for your formulas?

If you want to do the clearing manually, you can follow these steps:

•  Press F5. Excel displays the Go To dialog box.

•  Click the Special button. Excel displays the Go To Special dialog
    box.

•  Select the Constants button. The four check boxes under the
   Formulas option then become available.

•  Make sure that all the check boxes under the Formulas button
   are selected.

•  Click OK. Excel selects all the constants (cells that don't contain
   formulas) in the worksheet.

•  Press the Del key.

This works great if you only need to clear out the non-formula contents of a worksheet once in a while.