excel numbers how to sort by size

Excel sorting needs to open the excel** file first, then select the content you want to sort, click on the data above, open the sorting function, choose to sort with the currently selected area, and finally click Sort, OK.

Microsoft Excel is one of the components of Microsoft Office, Microsoft's office software.

Excel is an important part of the Microsoft Office Suite.

It can carry out various data processing, statistical analysis and auxiliary decision-making operations, and is widely used in management, statistical finance, finance and many other fields.

We usually use the sorting is generally sorted by the value from large to small, or from more to less, we want to sort by January sales from less to more, just select any cell in column d, click [Start], click [Sort and filter] and select [Ascending].

The column to be sorted by the dots The data above the dots will be sorted, and if you want to sort from largest to smallest, you will choose descending order.

1 Click a cell on the column you want to sort, 2 click the sort button (the two buttons a-z z-a).

If you have Excel2007, click the Data menu before you do Action 2.

First, open the excel program and enter the excel program to carry the main interface.

Second, bury and eliminate, and then, open a ** data that needs to be sorted from large to small in the excel program, and select all of them.

3. Finally, click the "descending" icon at the top of the main interface of the excel program, and you can make the excel numbers hidden bends sort from large to small, and the problem is solved.

1. First of all, open the excel that needs to be sorted by numbers, enter some data into **, use the mouse box to select the numbers that need to be sorted by the size of the numbers, and you can also include some content related to the rock type, but it is best not to include other numbers.

2. Then, in the top series of options, left-click and select the data option in the menu bar.

3. Then, find these three options in the figure under Data, which are direct ascending and descending arrangement, and other sorting methods.

4. We left-click the Select Sort button to select the main keyword, that is, the row and column where the number is located.

5. Select ascending or descending order, and after left-clicking to confirm, the selected part of the rough open will be reordered according to the setting.

At present, people only use a small part of the functions of the office automation software excel, and most of the functions are not used because they cannot be used or cannot be used directly; In the face of the complex and large number of data in the worksheet, to sort its size, I will tell you how to set the data sorting right away.

Excel**Set the method of sorting by the size of the data 1、We now open a worksheet in Excel, click the "Start" tab of the ribbon, and select the icon of "Sort and Filter" in the "" area. Then click on its inverted triangle button and select the "Custom Sorting" command in the pop-up drop-down menu;

The Excel setting sorts by the size of the data step 12. Then the window will pop up a "sort" dialog box, click the drop-down button of "Main Keywords" under "Column" to select, select "Value" from the drop-down button under "Sort by", select "Ascending" under the "Order" option group and then click "OK", for example, here we choose the column "Mathematics" to ascend;

The Excel setting sorts by the size of the data step 23. After setting, return to our worksheet, and you can find that the data in the column of mathematics is in ascending order from small to large, as shown in the following figure;

Excel** set to sort by the size of the data step 3You may also like:

1.How excel sorts by size of data.

2.07Excel**How to sort.

3.Excel to adjust the operation method to set the cell size as large.

4.How to set the data sorting in Excel.

5.Excel How to sort by numeric size.

6.How to set data sorting in Excel.

7.How Excel uses data sorting.

8.Excel** sorts by numeric size.