Sorting Subtotals
Hi,
Once you have your subtotals in place, highlight the whole range go to Home,
in Stlyes choose format as a table, then take the column where you have the
subtotals and uncheck what is 0 or "Blanks"
If this helped you please say yes, thank you
"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!!
|