Ellen

I'm not sure what you're asking. A formula or a subtotal gives a result
based on the contents of one or more cells elsewhere. To clear the column,
you need to delete the data in the other cells.

Am I missing something ?

Regards

Trevor


"EllenSwarts" wrote in message
...
How do I clear a column of data only without erasing the formulas?
Similarly, I have several sections of subtotals, where the data being
subtotaled is formula driven. Can I protect the subtotal formulas so that
I
can paste special values only without pasting over the subtotals?