Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Sorting Rows

I want to sort multiple rows, but seem to only be able to do one at a time. I know that to sort multiple columns, I can highlight as many columns as I want and then select A to Z on the Toolbar. But this doesn't seem to be the case for sorting rows. In terms of sorting rows, the only thing I can seem to do is to go into Data--Sort--Options--Select Left to Right. I can then sort a single row, and from this window it looks like I may--although I haven't figured out how to get it to work--be able to sort three rows, but I cannot tell how I might be able to sort more than three rows. For instance, suppose I have the following data

3, 2, 1
6, 5, 4
98, 97, 96
33, 32, 21

I want to be able to select all of these rows and quickly sort them as follows:

1, 2, 3
4, 5, 6
96, 97, 98
21, 32, 33

Thank you
 
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
blank rows and sorting problem..plz help me... naughtyboy Excel Discussion (Misc queries) 2 August 8th 06 08:03 PM
sorting multiple rows CCOD Excel Discussion (Misc queries) 1 July 13th 06 06:53 PM
how to keep adjacent rows linked when sorting with lists adaire New Users to Excel 2 July 3rd 06 01:59 PM
identically size merged cells for sorting rows julieanne12 Excel Discussion (Misc queries) 1 August 24th 05 11:26 AM
sorting out columns but only for some rows Sam Excel Discussion (Misc queries) 5 April 23rd 05 03:20 PM


All times are GMT +1. The time now is 10:05 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"