- 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.