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.

Sorting subtotaled amounts in excel
 

Hi,

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

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=530860

Sorting subtotaled amounts in excel
 

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 EditGo 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