Common methods and flexible techniques for data sorting by Excel

When using Excel to make related data tables, we can use its powerful sorting function to browse, query, and statistic related numbers. Below, we take the "Basic Employee Status Registration form" shown in Figure 1 as an example to fully experience the sorting function of Excel.

First, quick sort

If we want to arrange employee data by a column attribute (such as "seniority" from long to short), you can do this by selecting any cell in the seniority column (such as I3), and then clicking the Sort Descending button on the Standard toolbar (see Figure 1).

Tip: ① If you press the Sort Ascending button on the Standard toolbar, the seniority is sorted from short to long. ② if the sorted objects are Chinese characters, they are sorted in alphabetical order. ③ If the sorted object is a western character, it is sorted in Latin alphabetical order.

Second, multi-conditional ordering

If we need to according to "education, seniority, title" to the data sorting, you can do this: select any cell in the data table, perform the "Data → sort" command, open the Sort dialog box (Figure 2), the "main keywords, secondary keywords, the third keyword" respectively set to "education, seniority, title", and set the sort order (ascending or descending), and then press the OK button.

Computer Tutorials

Sort by stroke

When "name" is sorted, people like to do it by "Last Name stroke": Select any cell in the Name column, perform the data → sort command, open the Sort dialog box (see Figure 2), click the Options button, open the Sort Options dialog box (Figure 3), and select the Stroke sorting option. Make sure you return to the Sort dialog box, and then press the OK button.

Tip: If you need to sort the data by a row of properties, just select the Sort by row option in the Sort Options dialog box above.