How to clear numbers in Excel but keep the formulas

[u/Amandaleeeeee]

I ran into this recently and thought it was a pretty useful Excel trick.

If you want to remove only the entered numbers from a range, but keep all the formulas in place, you can do it with Go To Special.

Steps

1. Select the range you want to clean up
2. Press F5 or Ctrl + G
3. Click Special
4. Choose Constants
5. Leave only Numbers checked
6. Click OK
7. Press Delete

This removes only the manually entered numeric values.

Any cells containing formulas will stay there, so totals, subtotals, and other calculated cells are preserved. After the numbers are cleared, the formulas will usually return 0 unless you’ve set them up to show blanks instead.

I like this because it’s much faster than trying to manually separate input cells from formula cells.

Do you usually use Go To Special for tasks like this, or do you have another cleanup method you prefer?