How to directly and automatically generate a sort sequence number in Excel

If it's filling 1234567 ... In this case, you can enter 1 and 2 in the first two cells of a column, and then select these two cells, there is a filling handle (black square) in the lower right corner of these two cells, point the mouse pointer to the black square, then the mouse pointer changes from a hollow cross to a solid cross, and then click the left mouse button and drag it downward.

rank(number,ref,order)number

Find the number of the ranking for the need.

ref is an array of numbers or a reference to a list of numbers. Non-numeric parameters in the ref will be ignored.

order is a number that indicates how you are ranked.

If. order

For. 0 (zero) or omitted, microsoft

Excel is based on the ranking of numbers.

ref is a list in descending order.

If. order

Not zero, Microsoft

Excel is based on the ranking of numbers.

ref is a list in ascending order.

Add a few more secondary columns.

Used to restore the previous sorting.

I made an excel, you can go down and read it yourself.

The landlord doesn't know the rank function?

For the ranking function of Excel, please refer to the help ...... for details

1. Open the form that needs to be automatically numbered.

2. Then right-click the serial number you want to modify, here 20 is taken as an example.

3. Then, right-click on the selection box and select the last serial number in the form.

4. Right-click the Autofill button in the lower right corner of the selection box and select the filling order in the pop-up menu.

5. Right-click to fill the sequence to automatically fill in the serial number.

1.Select the first cell that requires an ordinal number. The first step is that you need to add a function for the cell.

2.Click on the "Insert" option in the "Menu Bar", select "Functions", and click.

3.In the Insert Function window, select Find & Reference in Select Type, and select Row in the function that appears below.

4.Ignore the pop-up window and click on the input bar above.

5.Enter -2 after the parentheses, and the window just now becomes calculated to be equal to 1. Are you sure.

6.The contents of the selected cell are displayed as 1, and its contents are displayed in the input field.

The first way to add an ordinal number.

The next step is to add all the ordinal numbers. When the bottom right corner of the cell turns into a black cross, hold down the left mouse button, drag down to the end of the content, release the left button, and you're done. The effect is shown in the accompanying image in the introduction.

7.The second way to add a sequence number.

Select the cell with sequence number 1, hold down the shift key, and click the last cell with the left mouse button to set the sequence number. Complete Select All.

8.Select the "" option in the "Menu Bar", select "Fill Down" in "Fill", and the serial number will be added automatically. The effect is shown in the accompanying image in the introduction.

In these two methods, the order of the sequence numbers will be automatically changed when the entire line is deleted.

Isn't it possible to sort directly, if not, separate the columns, and separate the parts of the form such as: jsdj01-01 for sorting.

First select the cell where your "part number" is located, and then I don't know what version you use, if it's the 2007 version, click the "Start" menu, find the "Sort & Filter" button, and select the points in ascending order. If it's the 2003 version, it's the same.,It's just that I don't remember the "sort and filter" button in**.,Just look for it yourself.。

Click the small arrow on the corner of "Part Number" at the top, and select "Sort in ascending order" from the drop-down menu

First, divide the number and text into 2 columns, and then sort them.

To extract these two parts first, sort them by these two parts of the keyword.

Set up automatic sorting for Excel.

You can sort first, then column.

1. First of all, in the computer, create a new worksheet, as shown in the figure below.

2. Then in the page that opens, you can see that this is a common number. , as shown in the figure below.

3. At this time, through the =row() formula, an automatic number, 6 is a variable = line number-1, as shown in the following figure.

4. Then delete one line, as shown in the figure below.

5. You can find the difference between automatic numbering and ordinary numbering, as shown in the figure below, excel automatic sorting number is completed.

After opening the excel software, create a new blank**, click on the upper left corner of the cell and enter the number "1". Press and hold the "Ctrl" key on your keyboard, pull the "dot" in the lower right corner of the cell where the number 1 is located, and select other blank cells. When you release the mouse, it will automatically fill in the order of the first number, detailed steps:

1. After opening the excel software, create a new blank**, click on the upper left corner of the cell and enter the number "1".

2. Press and hold the "CTRL" key on the keyboard, pull the "dot" in the lower right corner of the cell where the number 1 is located, and select other blank cells.

3. After releasing the mouse, **will be automatically filled in according to the order of the first **number**.

4. If the sorting on our ** is wrong, we will box select the wrong cells, and then press and hold Ctrl to pull down.

5. If you don't hold down the Ctrl key when pulling down, then all the selected cell data will be replaced with the data of the first cell, after the cell box is selected, click the "small icon" pop-up window in the lower right corner and click "Fill Sequence".

6. After the setting is completed, the wrong serial number will be changed.

1, first we make a **, with a serial number, 2, and then, we click on the first serial number "1", 3, and change it to "=row()-1

4, then, we mouse click on the blank space, 5, then, we delete one of the serial numbers, take a look, 6, then, we put the mouse in the lower right corner of the serial number "1", let the mouse become black "+" OK, 7, then, after becoming a black "+" sign, then directly double-click the mouse, and then look at the effect, 8, so that we are done, we delete any line, he will be automatically sorted,

The automatic sorting method of excel numeric number setting is as follows:

Tool Material: Dell Vostro5468 computer, Windows 10 system, Excel 2019 version.

1. Take excel** as an example, first open a blank excel**, click on a blank box, and enter the number 1.

2. Then hold down the CTRL key and pull the [Fill Key] in the lower right corner of the cell where the number 1 is located to select the blank cell.

3. Then excel** will automatically fill in the order according to the first **number**.

4. If you want to modify and sort the original data automatically, you can modify it according to this method, first modify the slag data of the cell, and then press and hold Ctrl to pull down, you can replace the selected wrong data.

5. When pulling down, if you do not hold down the Ctrl key, then all the selected cell data will be replaced with the data of the first cell, you can click the [Self-Parallel Beam Gesture Fill] button that appears in the lower right corner and select [Fill Sequence].

Material Tools: Excel2010

1. Open an Excel** that needs to be numbered.

2. Delete the number in **.

3. Enter Huai=row in the cell where you want to display the number, and double-click the row function.

4. Enter -2 after the row function (where 2 represents the number of non-data rows), and the complete formula is: Shoumengyou = row()-2.

5. Place the cursor at the position marked by the red wireframe, drag it down, and fill the number in the full sequence number column.

6. The number is filled.

7. Select one of the lines to delete.

8. After deleting a few lines, the number will change automatically.

Material Measuring Tools: Excel2010

1. Open the Excel2010** document.

2. First enter the land into the cell =row(a1) and press the enter key.

<>4. Finding that other ** is selected.

5. Press Ctrl+D, you can see the serial number from 1 to 20.

Select the data to be sorted, click [Data] - [Sort and Filter] - [Descending], check [Expand Selected Area] and click [Sort], enter the first cell in the [Ranking] column, place the mouse in the lower right corner of the single forest defeat grid, hold down and drag down to select the whole column when it becomes a cross, click [Auto-fill ruler spring game option], and select [Fill Sequence].

If you want to automatically sort numbers in excel, there are two ways, one is to enter a number, then pull it down, and then choose to fill in the serial number. The other way is to enter two connected numbers and pull them down directly to achieve automatic sorting of numbers.

Enter 1 in **, and then press enter.

Then select the cell, then place the mouse in the lower right corner, and pull down when the cross symbol appears;

After the drop-down is completed, click the pop-up button;

Then click to fill in the serial number;

There is also a simple way to dig pants, directly enter 1 and 2, and then place the mouse in the lower right corner, the cross symbol appears, and directly pull down;