If you have an Excel worksheet that contains formulas in some cells and you want to clear all he cell contents without deleting the formulas, this is how you do it.
- On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. Alternatively press CTRL+G or F5 to open the Go To dialog box and click on Special.
- On the Go To Special Dialog box select Constants.
- Click OK.
- This will select only the cells that contains numbers or text. Cells that contain formulas are not selected.
- Now you can press the delete key to delete the contents of the selected cells.