[SOLVED] 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://groups.google.com/group/micro...87933f657df337

HTH
Carim

[gls858]

ep wrote:
> 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