How to use sort option in Microsoft excel?

Sort option is the one of the most useful option among the variety of option available in Microsoft excel. This option will make easier your works. I will explain how to use this by an example.

Please see the image below.

Now we think that we want to sort the payments from the lowest amount to highest amount.

In order to do that, select the entire table except headings.

Now click on the data tab and click on the Sort option.

Now select the “Payments” from the sort by drop down list and select “smallest to largest” from order drop down list. And click Ok.

Now you can see the Payments column is appear smallest to largest value.

Dear Davis,

If you want to learn Excel well(Any version),there is lot of states to identify. I have given below a clear explanation with pictures, which are the basics of MS excel. Please refer well and get more knowledge about  this.

Sort by Multiple Columns of Data Excel

Sort multiple columns by using Excel 2007's custom sort feature.

Sort data by cell color Excel

Use Excel sort  feature to sort data by cell color in Excel.

Sort  data from Font color in Excel

Use the Excel's sort feature to sort data by font color in Excel.

Sort data in Excel

Use excel's sort features to perform a simple sort by one column.

Sort data in Excel 2003

Use 2003's sort features to perform a simple sort by one column.

You can find more and more. Please use below links and get a lot of short facts about Excel.

• http://office.tizag.com/excelTutorial/excelsorting.php
• http://office.microsoft.com/en-us/excel-help/sort-a-range-HP005202954.aspx

Thanks.