Question: how to clear data from excel spreadsheet but not formulas?
Answer: Press F5. Excel displays the Go To dialog box. ... 
Click the Special button. ... 
Select the Constants radio button. ... 
Make sure that all the check boxes under the Formulas radio button are selected. ... 
Click OK. ... 
Press the Del key.