I need to do this for an assignment and it isn't working. For example, I have
2 rows of numbers, each row about 15 columns in length and each number has
it's own designated cell. These numbers are not in numerical order.

I need to sort these rows and columns so that they are both in numerical
order with each other, for example:
15 20 25 30 35 40
45 50 55 60 65 70

However, I can only get the first row to be in numberical order by itself
and the second row doesn't order at all, like this:
15 25 30 45 60 65
40 50 20 70 55 35

I know I could just place the second row next to the first and sort that way
and then cut and paste back, however the data sample I am working with has
over 300 numerical characters and this would take way too long.

I'm using the Excel 2003 version and i've gone into data - sort and tried
every combination. Please help - this is driving me crazy.