How do I clear a column of data without clearing the formulas?

I want to zero out a column of data, but not the subtotal formulas. How can
I do that easily without going to every cell?

Hi

Select your column
then choose edit / goto / special - constants - ok

this will just select the non-formula cells then press the delete key

cheers
JulieD


"EllenSwarts" <EllenSwarts@discussions.microsoft.com> wrote in message
news:DD518142-47BC-438D-BE23-8DF1E9F72042@microsoft.com...
>I want to zero out a column of data, but not the subtotal formulas. How
>can
> I do that easily without going to every cell?

qlso look at:

http://www.mvps.org/dmcritchie/excel...s.htm#dpalette