I want to sort multiple rows, at the same time 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. 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 a may (although haven't figured out how to get it to work) 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
i forget to mention at the same time! Not one by one!
let's say i have 200> rows so i would like to sort them form min to max but all together!
so...
THANKS IN ADVANCE
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
i forget to mention at the same time! Not one by one!
let's say i have 200> rows so i would like to sort them form min to max but all together!
so...
THANKS IN ADVANCE