Recently while working on an Excel sheet i required a need to sort a particular column by an order.At office i was working on Office 2003 and it made me nuts while figuring out the exact thing.Office 2010 has this thing in pretty much simple and easy mode.

For Office 2003:
1.Select the cells of a particular column which you want to sort.
2.Go to Menu->Data->Sort
3.Select Sort by “Column name” & “Order” Ascending or Descending
4.Press OK

WVJ_Excel_Sort

For Office 2010:
1.Select the cells of a particular column which you want to sort.
2.Go to Menubar->Data->Sort
3.You can either select direct sorting (Ascending or Descending) or you can select more options
4.For more options you can Sort on “Cell data,Color,icon” Sort by “Column name” and “Order” Increasing or decreasing.
5.Press OK.

Interface is much different in both the versions.If Excel 2003 Screenshot required you can comment in the post.

Leave a Reply

Your email address will not be published. Required fields are marked *