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.
- Select everything in your spreadsheet except column and row headings.
- Press the F5 key, or Ctrl+G (for Go To), or click the Find & Select button on the ribbon and then choose Go To.
- In the Go To window, click the Special button.
- In the Go To Special window, select Constants and click OK. This will select everything within your highlighted range that isn’t a formula.
- Press the Delete key on your keyboard.
You’ll be left with just your formulas so your spreadsheet will be ready to use again.
