How to use sort option in Microsoft excel?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Henry george
Answered By 0 points N/A #145305

How to use sort option in Microsoft excel?

qa-featured

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.

Best Answer
Best Answer
Answered By 10 points N/A #145306

How to use sort option in Microsoft excel?

qa-featured

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.

Answered By 563040 points N/A #291396

How to use sort option in Microsoft excel?

qa-featured

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.

Microsoft Office Excel select cells to sort

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.

Microsoft Office Excel sort feature

Login/Register to Answer

Related Questions