How to use sort option in Microsoft excel?
I am very new to Microsoft excel and have a little knowledge.
I have seen some experts are using sort option for their works.
Can somebody explain me how to use the sort option in excel.
Thanks.
I am very new to Microsoft excel and have a little knowledge.
I have seen some experts are using sort option for their works.
Can somebody explain me how to use the sort option in excel.
Thanks.
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.
Thanks.
Sort is a feature in Microsoft Office Excel that allows you to rearrange the data in two different orders: ascending order and descending order. In ascending order, the data is rearranged from the smallest value up to the highest. In descending order, the data is rearranged from the highest value down to the lowest. The two are the opposite of each other.
To use sort in Office Excel, data must be present already on the sheet or table. When you are ready to sort the data or there are already enough data to be sorted, just select all the cells of the data in a row or column to be sorted and then click “Sort & Filter” under “Editing” group in the “Home” tab.
Select either “Sort A to Z” or “Sort Z to A”. And that’s it. The data will be rearranged according to the order you selected.