software

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-gt;A but I still get the message:
quot;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 againquot;.

Any suggestions?

Thanks.
Hi,

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

HTH
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=530860ep wrote:
gt; I have subtotaled a spreadsheet and now wish to sort by the subtotals.
gt; I have tried collapsing the outline so that I only see the subtotaled
gt; amounts and then sorting Z-gt;A but I still get the message:
gt; quot;This removes the subtotals and sorts again. If you want to sort the
gt; subtotaled groups, choose the Cancel button; then collapse the outline
gt; and try againquot;.
gt;
gt; Any suggestions?
gt;
gt; Thanks.
gt;
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 toolbarIf you want to copy just the subtotals to a new area of the workbook:Select the cells that you want to copy
Choose Editgt;Go To
Click the Special button
Select Visible cells only
Click OKClick the Copy button
Select the cell where you want to start the paste
Click the Paste button.

gls858