Sorting subtotaled amounts in excel

[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.

 

[Carim]

Hi,

Possibly your answer is in this post :
http://tinyurl.com/zfmky

HTH
Carim

 

[gls858]

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.

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