Last response didn't seem to post. If i understand your problem correctly
this will work. Hilight the data you want to sort the go to
Data-Sort-sort-Options and check the sort left to right box.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"mrbalaje" wrote:

I have data in multiple columns. In all the column in Row 1, I have a number.
I want to sort the columns according to the numbers in the Row 1.

Is there any way in Excel to do it. I am using Excel 2003.