# Sorting Rows

#### sfraibe2

##### New Member
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 be able--although I haven't figured out how to get it to work—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

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
22
Views
159
Replies
4
Views
60
Replies
3
Views
29
Replies
13
Views
133
Replies
1
Views
46
Legacy 456155
L