How do I sort a list in Microsoft Excel?

How do I sort a list in Microsoft Excel?



In Microsoft Excel, you can use the Sort feature to perform many actions with lists of data. Users are generally looking alphabetize many text values or arrange a list of numbers in order from lowest to highest or from highest to lowest. To proceed, follow the instructions in the next section.

Note: Details on how to sort more quickly are in the second section farther down the page.

Using sort to organize a list

• In Excel, highlight the values in a column that you want to organize.
• Click on the Data tab at the top of the program window.
• Click on the Sort option.
• Make sure the Sort by option is set to the column in which you have highlighted. If the column of data has a header name, you can check the My data has headers box in the upper right-hand corner to use the header name in the Sort by option.
• Under Order, click the down arrow.
• In the drop-down menu that appears, select the option that sorts the data to your liking.
• Click OK to sort the highlighted values.

 


Using the Quick Sort feature

If you only need to organize your data in ascending or descending order, you can use the Quick Sort feature. Highlight the values you want to sort, then on the Data tab, click on either the Sort A to Z option or the Sort Z to A option.

Related Articles :)
How to create a spreadsheet.
How to create a custom sort in Microsoft Excel
Help, examples, and information on Excel formulas.
Easily sort data in Microsoft Excel by using the auto filter.
Use our online text tool to sort and otherwise manipulate any text.
See our sort definitions for further information and related links on these terms.

Read More