Sorting Rows

[sfraibe2]

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

 

[tmcfadden]

There must be an easy way to do this with tables, but I've never used them.

To use a macro to sort that table, check out this link: http://www.lacher.com/examples/lacher17.htm

-Tim