Tip of the week # 420
26 April 2014

Last updated 7 November 2023 - simplified instructions

Find and delete all data but keep Formulas, Conditional Formatting and/or Data Validation (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. No need to select that data, but perhaps you want to kick off making a copy of your sheet or book.
  2. On the Home tab, in the Editing group, click Find & Select, followed by Constants.
  3. Press the Delete key on your keyboard.

This will delete all the data, but leaves the Formulas, Conditional Formatting and/or Data Validation, ready for next year's tax year.