How to delete data in Excel but not formulas?

I have a spreadsheet, lets say with columns a to z and 3000 rows of data, each field filled out. Thing is, i need to copy this data to another sheet, and re-use the current sheet, maintaining the formulas. I have for example some formulas and vlookups in columns g, h and k. If i plain delete the data, i lose the formulas. I could just delete the data in columns without formulas and leave the others but this will be time consuming. Is there some kind of delete function that will work on deleting data (values) in cells, but keep any formulas?How to delete data in Excel but not formulas?
Very easy to do.





Press F5 to display the ';Go To'; box.





Select the ';Special'; button.





Choose the ';Constants'; button and remove the ticks from the Text, Logicals, and Error boxes.





';Numbers'; should be the ONLY box ticked.





When you click ';OK';, every numeric cell across the spreadsheet will be selected.





Now manually press ';Delete'; to delete the values.





If you have text in the spreadsheet aswell, you would just de-select the ';Numbers'; option and select the ';Text'; option.





That function can also be used to do many neat tricks.








Let me know if you have any problems.





Andrew

Bracelet

necklace