Excel how to customize the numbering

After selecting the main keyword in the excel sorting dialog box, click the option, you can choose the custom sequence as the sorting order, which makes the sorting convenient, fast and easier to control, so how to customize the sorting method for cell text or numbers in excel, let's take a look!

Method steps.

1. First of all, we establish a set of test data in Excel blank cells for custom sorting test.

2. Then select our test data, and click [Sort & Filter] - [Custom Sort] in the menu bar.

3. In the pop-up dialog box, select [Main Keyword], and then select the sorting criteria under Sort by.

5. Next, we click [Options] on the diagram to pop up the sorting options menu box, and select the direction and method.

Precautions. You can choose to sort by column or by row, if the order of the previous ranking is Paste Special, and then transpose after the order is completed.

The above is how to customize the sorting method of cell text or numbers in excel, the operation is very simple, friends who will not can refer to this article, I hope it can help you!

Auto-set numbering belongs to the sequence with the autofill step of one, and the auto-fill sequence can be used in the following ways:

1. While pulling down, hold down the CTRL key.

2. Pull down directly, after the drop-down is over, click the shortcut menu displayed in the lower right corner and select the fill sequence.

3. Enter 1 and 2 data in the upper and lower cells respectively, then select these two cells and drop down.

Fill Sequences: Not only can you fill in the sequence number, it can also be filled in a variety of forms, such as: equal difference, equal ratio, date, etc., in addition, if these fills do not meet the user's requirements, you can also add custom sequences.

1. Open the ** 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. After the disadvantage is matched, right-click the selection box and select the last serial number.

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

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

Here, taking excel2007 as an example, automatic numbering can be achieved by using the function rows(). The specific steps are as follows:

1. First, select the table in which you want to set the automatic capacity number.

2. Then delete all the numbers in the table.

3. Enter the function row under the serial number, and then select row on the pop-up page.

4. Then enter the formula exactly as "row() 2".

5. Place the cursor in the place marked by the red wireframe and drag down to fill the complete serial number column.

6. Finally, you will see that the numbers have been filled in order. If you delete one of the columns, the number will change automatically.

1. First select the ** you want to set up automatic numbering.

2. Then delete all the numbers.

3. Enter the function '=row' below the serial number, and then select [row] on the page that pops up.

4. Then enter the formula as "=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. Finally, you will see that the numbers have been filled in order, and if you delete one of the columns, the serial number will be automatically changed.

The first step is to open Excel and left-click in a cell in the first row. Step 2: Find the function button and click it. Step 3: Select "row" and click to go, and then click OK.

Fourth, the numbers can be pulled down in order to achieve automatic numbering.

Method 1: Open Excel**, then enter the serial number "1" in cell A1, move the mouse to the lower right corner of cell A1, and you can see that the Guangwu silver reputation mark has become a "ten" word. Hold down the Ctrl+Left Mouse button on your keyboard, and then drag the mouse towards the bottom of the cell, and you will see the ordinal number autofilled.

Method 1: Enter 1 in cell B4, enter 2 in cell B5, select cell B4:B5, move the mouse to the lower right corner of the selected area, turn the mouse into a cross shape, press the left mouse button and drag down to automatically increment the serial number.

Use the mouse to select these two cells, then point the mouse pointer to the lower right corner of the box selection area, stop moving the mouse when the mouse pointer changes to a cross shape, and then the mouse points to the fill handle of excel.

Open the excel workbook and select the cells you want to number. In the Main Toolbar, click the Data tab. In the Data Tools group, click the Sequence button.

In the Sequence dialog box, enter the starting number and delta value. Click the OK button to generate an automatic number in the selected cells.

Open the ** that needs to be automatically numbered and proceed to the next stepIn the corresponding column that needs to be numbered, enter 2 to proceed to the next step. Select the ** where 2 is located, click the cross button at the bottom right of it, and pull it down to automatically number it. If there are many numbers in the number, you can use the autofill function of Excel.

Excel often needs to use the automatic numbering function in excel to enter numbers, how to use the automatic numbering function? Here's how I brought me how to use auto-numbering in Excel, I hope you will be inspired after reading it!

How to use auto-numbering in excel:

Use Auto Numbering Step 4: So what do we do, let him arrange it automatically, we click left to select cells 1 and 2, and then click on the lower right corner of the cell, drag it down as shown in the figure.

The steps to automatically number the serial number after excel filtering are:

First, open one of the tables in Excel, and then press and hold Ctrl to serial numbers.

Second, after filtering some names, you will find that the sequence number is not sequential.

3. Next, click on the right to recreate an ordinal number column, enter kis=subtotal in this cell, and then select 3.

4. Then enter the full formula =subtotal(3,b$2:b2) in the cell.

5. After selecting the serial number, then press and hold the Ctrl+Enter shortcut key on the keyboard to refresh the serial number, and you can set it to automatic numbering.