Tip of the week # 420
26 April 2014

Find and delete all data but keep formulas (Microsoft Excel)

Have you ever had the need to keep your formulas in a worksheet, but get rid of all the other data? For example, you might want to create a new sheet for the new tax year, containing exactly the same headers and formulas, but not the data from the previous tax year.

Here's how:

  1. Select the rows and/or columns that contain the formulas. (Remember the quick way to select a range of cells? See tip_306.php)
  2. On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. (Or press CTRL + G and click on the Special button.)
  3. In the Go To Special dialog box, click the Constants radio button.
  4. Click OK.
  5. Press the Delete key on your keyboard.

This will delete all the data, but leaves the formulas, ready for next year's tax year. (Thanks for the inspiration, Melissa.)