How to delete data but keep your formulas on a worksheet in Excel

Have you ever found that at the beginning of the financial year you need to make a copy of the previous year’s workbook? If so, you’d need to delete all the old year’s data, but you would really like to keep your formulas in the worksheet. By using the Go To dialogue box, there is a quick and easy method to do this.

Applies To: Microsoft® Excel® 2010, 2013 and 2016 for Windows

  • Make a copy of the desired worksheet.
  • Press F5 on the keyboard (The Go To dialogue box will pop up).

  • Select Special.
  • Select Constants.

  • Select OK.
  • All cells containing constants (everything except formulae) will be selected.
  • Press Delete on the keyboard.

That is an easy and quick method to delete all non-formula data but keep your formulas on a worksheet.