Have you ever built a spreadsheet and then wanted to re-use it, say for the next year, but realized you forgot to save a blank copy? That means you have to delete all the data that was entered into the workbook while being careful not to delete any of your formulas. That can be a tedious process, but it doesn’t have to be. Here’s an easy way to delete everything that’s not a formula.

  1. Select everything in your spreadsheet except column and row headings.
  2. Press the F5 key, or Ctrl+G (for Go To), or click the Find & Select button on the ribbon and then choose Go To.
  3. In the Go To window, click the Special button.
  4. In the Go To Special window, select Constants and click OK. This will select everything within your highlighted range that isn’t a formula.
  5. Press the Delete key on your keyboard.

You’ll be left with just your formulas so your spreadsheet will be ready to use again.