LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ep
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Please do you know how to convert amounts to text in excel JOSEROCHA Excel Discussion (Misc queries) 1 April 3rd 06 07:13 PM
sorting range changes sum??? (excel) bertbarndoor Excel Worksheet Functions 4 March 3rd 06 04:31 PM
HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL SNOWBREEZE3 Excel Worksheet Functions 1 October 13th 05 09:10 PM
Excel and Sorting Justin Excel Discussion (Misc queries) 1 June 16th 05 11:16 PM


All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"