Sorting subtotaled amounts in excel

  • Thread starter Thread starter ep
  • Start date Start date
E

ep

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.
 
ep said:
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.
Click to expand...
This is the answer I received from Debra Dalgleish:

Collapse the subtotals, so only the Company Names, and subtotal amounts
are visible. To do this, you should be able to click the 2 button in the
Outline bar.

Select a cell that contains a subtotal
Click the Z-A button on the toolbar


If you want to copy just the subtotals to a new area of the workbook:


Select the cells that you want to copy
Choose Edit>Go To
Click the Special button
Select Visible cells only
Click OK


Click the Copy button
Select the cell where you want to start the paste
Click the Paste button.

gls858
 
Back
Top