How to use sort option in Microsoft excel?

Asked By Branndy Davis 0 points N/A Posted on - 08/21/2012

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.

• Status: Open
• Question Views: 1257
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Henry george

Go To Solution

Answered By Geisha Nitta 0 points N/A #145305

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.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Henry george 15 points N/A #145306

How to use sort option in Microsoft excel?

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://mastersplitter.software.informer.com/download/?ca590d3-4.1

Thanks.

About Henry george

Questions
5

Answers
40

Best Answers
17

• Vote Up 0 Vote Down

• Posted on - 10/08/2012
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #291396

How to use sort option in Microsoft excel?

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 03/15/2017
• Question Category: MS Excel