how do u sort data by multiple rows? for example i have number values of 2
rows and 10 columns.
eg: 25 15 01 69 56 55 23 45 03 14 ...
58 68 33 45 02 07 78 90 53 44 ...
so on with multiple columns and multiple rows.

although there is a feature that allowes us to sort each row individualy, i
would like to know if there is a feature that allowes us to sort large
amounts of rows in one go. So that the above example - two rows should look
like this.

01 03 14 15 23 25 45 55 56 69
02 07 33 44 45 53 58 68 78 90

notice how they are sorted by single row. but without sorting each and every
row individually there needs to be a feature for multiple rows.



please email me back if theres already a feature like this at your earliest.
thanks



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc