View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
widman widman is offline
external usenet poster
 
Posts: 103
Default how can I print and sort JUST the subtotal lines, not the detail

Just filter it. Copy/paste values, choose a colum where there is nothing in
the subtotal line, looking for blanks, you will be left with the subtotals.

"kamaladg" wrote:

I have a subtotaled file, I want to print just the subtotals, and be able to
sort just the subtotals, not the detail that make up the subtotals