View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Sorting with Column

Select all your data, including the first row.

<Data <Sort <Options

Click on "Sort Left To Right".
Then <OK

Then pick sort on Row1, ascending or descending, then <OK.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"mrbalaje" wrote in message
...
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.