Sort data in an Excel data range or table

Sorting Excel data is an essential part of data analysis. You might want to do the following: List the names in alphabetical order, compile the product inventory level list in order from highest to lowest, and sort the rows by color or by icon. Sorting data helps you to quickly and intuitively display data and better understand the data, helping you organize and find the data you need to help you make more effective decisions in the end.

　　note to find the top or bottom values in a range of cells or a table (such as the first 10 or the last 5 sales), you can use AutoFilter or conditional formatting.

Learn about sorting

You can sort data in one or more columns by text (ascending or descending), numbers (ascending or descending), and date and time (ascending or descending). You can also sort by custom sequences, such as large, moderate, or formatting, including cell color, font color, or icon set. Most sort operations are done on columns, but they can also be done for rows.

Sorting criteria are saved with workbooks so that when you open the workbook, you reapply the sort to the Excel table, not the range of cells. If you want to save sorting criteria so that you can reapply the sort periodically when you open the workbook, it's best to use the table. This is especially important for multiple-column sorting or sorting that takes a long time to create.

Sort the text

1, select a column of alphanumeric data in a range of cells, or make sure that the active cell is in a table column that contains alphanumeric data.

2, on the Start tab, in the Edit group, click Sort and filter.

3. Do one of the following:

• To sort alphabetically by ascending, click Sort from a to Z.

• To sort in descending alphanumeric order, click Sort from Z to A.

4, you can perform a case-sensitive sort (optional).

　　How to perform a case-sensitive sort

1, on the Start tab, in the Edit group, click Sort and filter, and then click Custom Sort.

2, in the Sort dialog box, click Options.

3, in the Sort Options dialog box, select Case sensitive.

4, click "OK" two times.

　　question: Check that all data is stored as text if the column you want to sort contains numbers that are stored as numbers and stored as text, you need to format all numbers as text, otherwise the number stored as a number will be in front of the number stored as text. To format all of the selected data as text, on the Start tab, in the Font group, click the Format Cell Font button, click the Number tab, and then under Categorize, click Text. "

　problem: Remove all leading spaces in some cases, data imported from other applications may have leading spaces in front of them. Please remove these leading spaces before sorting.