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

[Guest]

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?

 

[JulieD]

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

 

[Guest]

qlso look at:

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