Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
blank rows and sorting problem..plz help me... | Excel Discussion (Misc queries) | |||
sorting multiple rows | Excel Discussion (Misc queries) | |||
how to keep adjacent rows linked when sorting with lists | New Users to Excel | |||
identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
sorting out columns but only for some rows | Excel Discussion (Misc queries) |