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.
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 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.
If you want to sort more than one column at the same time, after completing step 6 above, click the Add Level button. A second row will be added to the Sort window. Follow steps 4 through 6 above for each new level added for sorting.
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.
- 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 related information and links.
- Help and tips for Microsoft Excel.
- Microsoft Excel help and support.