How to use Excel to sort data?

When using Excel to make relevant data**, we can use its powerful sorting function to browse, query, and count related numbers. Below, let's take the "Employee Basic Information Registration Form" shown in Figure 1 as an example to fully experience the Excel sorting function.

1. Quick sorting.

If we want to sort employee profiles by a column attribute (e.g., "Seniority" from longest to shortest), we can do so by selecting any cell in the "Seniority" column (e.g., i3) and pressing the "Sort Descending" button on the "General" toolbar (see Figure 1).

Tip: If you press the Sort Ascending button on the Home toolbar, sort the Years of Service from short to long. If the sorted object is Chinese characters, the sorting is in the order of Hanyu Pinyin.

If the sorted object is Western characters, it is sorted in Western alphabetical order.

2. Multi-condition sorting.

If we need to sort the data by "education, length of service, and professional title", we can do this: select any cell in the data**, execute the "data sort" command, open the "sort" dialog box (Figure 2), set the "main keyword, secondary keyword, and third keyword" to "education, seniority, professional title" respectively, and set the sorting method ("ascending" or "descending"), and then press the "OK" button.

Computer tutorials. 3. Sort by stroke.

When sorting the "name", Chinese people like to press the "surname stroke": select any cell in the name column, execute the "data sort" command, open the "sort" dialog box (see Figure 2), click the "Options" button to open the "Sort Options" dialog box (Figure 3), select the "Stroke sorting" option, confirm to return to the "sort" dialog box, and then press the "OK" button.

1. First of all, you need to open the excel application.

2. Then you need to create a new workbook.

3. To facilitate the demonstration, enter the following data.

4. Then you need to select the data and click Sort.

Select the target data, select the "Data" menu, and then select Sort, which can be sorted from large to small or from small to large

Upstairs, it's a little simpler: first select the content you want to sort, include each list header, then click "Data Sort" in the dialog box to select "primary keyword", or secondary keyword, and then select the sort order, from largest to smallest or from smallest to largest. Just press OK.

In addition, there are two sort buttons in the menu bar of the window, which are "a---z"." 、“z---a"It is also a shortcut button for sorting.

See what you need to sort by. By amount, by quantity, from largest to smallest. There are many kinds.

Can you make the question clearer?

There are 4 steps for excel data from high to low.

Software version: excel2013

1. Open the excel** that needs to be processed, and select the data columns that need to be sorted.

2. Click "Sort & Filter" on the right side of the start menu bar.

3. Click "Descending" (so that the data is from high to low.) If you click on the ascending order, it is from low to high). The page that appears, because here you need to sort the values from highest to lowest, select the descending option.

4. In the pop-up prompt, press the default selection and click "Sort" directly, so that the values are sorted from high to low.

Go back to the main interface, so you can see that the data has been sorted from high to low.

Significance of excel:

Excel is essential in work, especially when it comes to reporting. Because in the actual work, the proportion of people who have mastered programming knowledge is very small, so it is impossible to use programming languages to obtain custom queries and make reports with professional reporting tools, and excel just solves the problems of the public.

Excel's report function is very powerful, and it also provides many useful functions, and can be programmed using VBA, which basically simulates all of a set of development languages, so it is simple and quick to get started.

So that many users no longer have strong programming skills, can quickly process data and make reports, and very flexible, the only flaw is that his data source is too dependent on ERP software, although in Excel we can play freely, but the data source limits the field, there is a little regret.

According to my experience, when using excel data sorting, you need to pay attention to the following details: 1. About the data area participating in the sorting Excel sorts the continuous data area where the cursor is located by default. A continuous data region is one in which there are no empty rows or columns within that region.

If you need to sort a continuous data region in a worksheet, you must first position the cursor on the column of the sort by column in the area, otherwise you will get an unwanted sorting result. Sort dialog box. Once sorted, blank rows are moved to the bottom of the selected area.

If you save the disk in the ground state, you can only restore the data state when you save the disk by pressing CTRL+Z. Second, make it a habit to add a new column to the worksheet and add a permanent serial number. So there is often a prompt that says "This operation requires that the merged cells all have the same size". The workaround is to split the merged cells so that they become normal cells. This is because when sorting using toolbar buttons, the first piece of data defaults to the header row. Solution: Add a new line before the first piece of data and fill in the content so that it pretends to be the title line.

There is no limit to the content to be filled in, and it is filled in until the right end of the continuous data area. It is recommended to use Ctrl+Fill handle to drag and select the whole row of cells to quickly fill in the same code data.

The following describes how to sort data in Excel:Tools: Lenovo laptop E460, Windows10, Excel2019.

1. To turn the data in the data field into a data list or a data**.

2. Find the ** function in the menu bar.

3. Click ** function will pop up a table creation window, click OK.

4. Look at the downward triangle arrow that appears in the header row, click on the triangle arrow to see that there are some sorting options. You can sell families in ascending order, descending order, and color order.

5. Take the name column in the grade table as an example, when you click Sort in ascending order, you can see that the score table is re-sorted in ascending order in this column, and a small upward arrow also appears in the title bar of the name column, indicating that the data in the table is sorted in ascending order according to this column.

1. First of all, open the EXC software, as shown in the example, you can see that the numbers in the "number" and "salary" columns marked in the red box in the figure are in an out of order, that is, there is no certain order, and it is ready to be arranged in a regular order.

2. Drag the mouse to select this **, and the whole ** will be gray after being selected.

3. Next, click on the "Data" tab in the upper menu bar.

4. Click the "Sort" function button.

5. In the pop-up prompt box, you can see a horizontal line marked in the red box. "Column: Refers to the key beats of your ** arrangement to filter from; Sort by: refers to the criteria of how you want to sort; Order: Refers to how you want to sort it. ”

6. A horizontal line marked on the red line. Sort according to the "cell value", that is, the data size of the unit, and finally sort "ascending", that is, all the data in the "number" column you selected are sorted from smallest to largest.

<>8. Select "Cell Value" as the sorting by.

9. Then select "Order" as "Ascending".

10. Click "OK".

11. Finally, it can be seen that the data in the "number" column that was originally out of order are all sorted according to the regular "ascending" rule.

12. Again, if the data is arranged regularly and the colors are inconsistent, you want to be stupid and arrange the colors in a certain order. As you can see, the "Name" column is divided into pink and green, with pink on top.

13. Select the "main keyword" as "name" first.

14. Then select the sorting basis as "cell color".

15. In the "Order" column, put the color you selected in different positions, select "at the top" or "in the middle", etc. (The demo has green at the top.) ）

16. After the most attack, looking at the results, the pink name was placed below from the previous top, and the green name was placed at the top.

The region where the data is received.

1. Select the data area where you need to define the name, and then delete the content in the name box in the upper left corner.

2. Then enter the name we need to define in the name box, here we enter the loss to mention "number 1", and then press the enter key. The name is defined here.

3. Now to apply it simply, we use the formula of subtracting the sum of the data region "number 1" from the sum of the data region "number 1", as shown in the figure, the formula "= sum (number pin) - sum (number 1)."

4. After selecting the region, it is shown in the following figure: