Excel - Delet data but NOT Formulas

How do I delete data from an excel worksheet, but leave the formulas in tact? Every time I delete data or 'clear contents' in cells containing formulas, the formulas are deleted? Thanks

 

You can't do that.
What exactly is your aim?
You can hide results of formulae - would that do? Or you can show the formulae instead of the results. Or you can stop the formulae from calculating by putting them in as text.
There may be other solutions to your problem as well, depending on what you're trying to do.

 

Well, of course. How could you expect anything else when you 'clear contents'? 'clear contents' means exactly what it says.

So, the solution is simply to not 'clear contents' for cells containing formulas.

 

I'm attempting to use the same spreadsheet (with formulas), along with a number of worksheets with formulas.... but want to use different input to create the desired results. I suppose I could just enter the new data, and then delete all the old entries... but that seems time consuming.

 

If you don't want to keep the old results, just replace the original set of data with the new set.

If you DO want to keep the old results, just make a copy of the sheet and replace the data on the new (copied) sheet with the new data. The easiest way to copy a sheet is to drag (usually to the right) the tab at the bottom of the sheet while holding down the Ctrl key. Then replace the old data on the newly copied sheet with the new data. BTW, you don't have to delete the old data, just move to the cell where you want the new data and type in the new value. It will automatically overwrite the old value.

If you only want to have one sheet with formulae on it (not sure why you'd want to, but you never know), you can do it by making up a sheet with your data on it (maybe call it DATA1), then, on another fresh sheet, put in your formulae, referencing the data on DATA1 to get your results.
You can then make up a third and other sheets with other sets of data, and to reference that data with your formula, do as follows:
rename the sheet with the original data (which is DATA1), then change the name of the new data sheet to DATA1.
So, if you have sheets DATA1 and DATA2 containing two sets of data, change the name of DATA1 to, say, DATA10, and then change DATA2 to DATA1. The formulae will then automatically reference the new data.