It hides the subtotals with zeros, but the detail that makes up the zero
subtotal is left there which is what I am trying to get rid of.

"Shane Devenshire" wrote:

Hi,

If hidding the 0 subtotals is sufficient then turn on AutoFilter and in the
column being subtotaled pick Custom from the autofilter drop-down and choose
does not equal from the first box and enter 0 in the second box. This will
hide all rows with 0's.

Likewise you can autofilter for 0's only.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Katy" wrote:

I have a spreadsheet that I am subtotaling. Most of the subtotals are zero,
but I am only concerned with the subtotals that are not. I need to keep the
detail. How can I segregate what has a zero total from another subtotal
without manually looking through the spreadsheet and copying and pasting? I
have already tried sorting by the total column, but it won't let me. FYI, I
am using Excel 2007.

Thanks!!