How to sort in ascending order in excel, how to sort in ascending and descending order in Excel?

Here's how:1. First of all, open the target DU file with 2007 excel software on the computer.

2. Then DAO selects the target column in the specialty, and clicks the "Genus Sorting" option in the data menu.

3. Then in the dialog box that appears, select the second option to confirm.

4. Then in the window that appears, set the sort by to numeric value and the order to ascend to confirm.

5. After completing the above settings, you can sort by column in Excel.

Commonly used shortcuts in Microsoft Excel to make **:

1. Press Ctrl+N to create a new excel file.

2. Press Ctrl+W to close the excel file.

3. Press Shift and click the close button to close all open excel files.

4. Insert a worksheet, every time you press the F4 key, a new worksheet will be inserted.

5. Press Ctrl+PageDown or PageUp to quickly view the worksheet. Press Ctrl+9 to hide the rows.

6. Press Ctrl+0 to hide columns.

How to set excel ascending and descending order:

1.First, open Excel and enter the data you need, 2Then select the cells that need to be sorted, click [Sort & Filter], 3

You can select [Ascending] and [Descending]. You can also select [Custom Sorting], 4Modify the sort basis and order, and click OK when you're done.

Summary:1Enter good data.

2.Select Sort and filter.

3.Select ascending, descending, and self-determinate sorting.

Excel also has powerful graphical features. Since 1993, Excel has supported Visual Basic for Applications (VBA).

How do you sort in Excel? It's simple, let me teach you!

Here's how:

1. Open Excel** on your computer and select the columns you want to sort.

2. After selecting the column you want to sort, click Sort in the toolbar.

3. After selecting ascending, a sort reminder window will pop up, be sure to select the first one, and then click Sort.

4. After clicking Sort, the data behind the sort sequence will follow.

Tips. 1. Press alt+down arrow to automatically generate a drop-down list based on the content you have entered;

2. Press alt+= to quickly insert the summation formula;

3. Press Alt+Enter to force a line break at the specified position;

4. Select the entire area and press Alt+; When selecting, you can skip the hidden area and select only the displayed area;

5. Press the alt+number key to enter special symbols: for example, alt+41420 can be entered, alt+41409 can be entered;

6. Press Ctrl+D to fill down. Select a cell with a formula or value and the n cells below to fill the value or formula.

As follows:

Operating Equipment: Dell Computer.

Operating system: win10

Operating software: excel file.

1. Open the target excel file on the computer and enter the main interface. Stupid land.

2. Suppose the content of excel needs to be arranged according to the data in the first column, and select the data in the first column with the mouse.

3. Then click on the "Data" option in the options bar of the upper menu.

4. Then on the page that appears, select the sorting method according to your personal needs. You can choose either ascending or descending order. The wheels are old.

5. Click to expand the selected area, if you don't select it, the data between the rows will be scrambled.

6. Then click the "Sort" button, and the content will be sorted in ascending order according to the data in column A. After completing the above settings, you can make Excel** Inner Wax Lift Capacity Sort by a certain column.

Reason: Custom sorting is set to ". Bu has no ridge.

Solution: 1. First of all, you can see that the sorting method is ".

2. Select the cell and click "Custom Sort" in "Sort and filter infiltration".

3. In the sorting window that opens, you can see that the "Order" option box has set a custom sorting method in the "Order" option box, and you need to click "Ascending" at this time.

4. Click OK to sort the selected cells in ascending order according to the default starting from 1.

As follows:

1. First of all, enter the number of different numbers in **.

2. Then enter the formula to sort these functions, 1 represents ascending and 0 represents descending.

3. Enter the formula =,a2:a12,1).

4. Press the Enter key.

Later, the first number will be sorted by the spike shed.

5. Pull down the formula and you will find that the sorting is not quite correct.

6. You can publicize it.

Add the absolute value symbol to it, and then enter the Zheng Shanxing pull-down to sort it correctly.

<>Summary:excel arranges the branch cavity order according to the content order of a column, and the specific operation steps are as follows: 1. Open ** and select all the contents.

2. Click on the data, and then click the sort button. 3. In the pop-up window, select Mathematics as the main keyword. 4. Select the cell value in Sort by.

5. Finally, in the order option, select ascending or descending. The above steps should be completed step by step in order, and do not skip any of them, otherwise the settings will fail.

Demo Environment Information:Computer model: ThinkPad Wing 14 Slim, system version: Windows10, software version: Excel2020.

excel sorts according to the order of the content of a certain messy column of the fierce grip shirt, and the specific operation steps are as follows:

1. Open ** and select all the contents. The specific operation steps are as follows: <>2, click Data, and then click the Sort button.

The specific operation steps are as follows: <>3. In the pop-up window, select mathematics as the main keyword. The specific operation steps are as follows:

4. Select the cell value in Sort by. The specific operation steps are as follows: <>5, and finally in the order option, select ascending or descending.

The specific operation steps are as follows: <> The above operation steps should be completed step by step in order, and do not skip any of them, otherwise the setting will fail.

1. First of all, you can see the sorting method in the open excel sheet is "1,10,100".

2. Bu Zheng selects the cell, and then clicks "Custom Sorting" in "Sort & Filter".

3. In the sorting window that opens, you can see that the user-defined sorting method is set in the "Order" option box. At this point, you need to click on "Ascending".

4. Click "OK" to sort the selected cells in ascending order starting from 1 by default.

1. First of all, you can see the sorting method in the open excel sheet is "1,10,100".

2. Bu Zheng selects the cell, and then clicks "Custom Sorting" in "Sort & Filter".

3. In the sorting window that opens, you can see that the user-defined sorting method is set in the "Order" option box. At this point, you need to click on "Ascending".

4. Click "OK" to sort the selected cells in ascending order starting from 1 by default.

It depends on your needs.

For example, to rank students in descending order of achievement, you would need to sort them in descending order of total score.