View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ep
 
Posts: n/a
Default Sorting subtotaled amounts in excel

I have subtotaled a spreadsheet and now wish to sort by the subtotals.
I have tried collapsing the outline so that I only see the subtotaled
amounts and then sorting Z-A but I still get the message:
"This removes the subtotals and sorts again. If you want to sort the
subtotaled groups, choose the Cancel button; then collapse the outline
and try again".

Any suggestions?

Thanks.