How to make a table ordinal in Excel

When you make a balance sheet in Excel, you often need to enter the serial number, in the actual application, the number of types there are many, some also need to use special symbols to express, or even automatically input and adjust the serial number, below to introduce a few tips on serial numbers.

Quick Input Serial Number

In Excel we can quickly enter some commonly used serial numbers, such as one or two ... A, B ... January, February ...

Enter the first two of the ordinal number, then select the two ordinal cell, the mouse to move to the second ordinal of the lower right corner of the mouse pointer is found to be a cross shape, then hold down the left mouse button dragged to the last cell of the input sequence number, release the mouse will find that the serial number has been automatically entered.

Custom Special serial Number

If you want some special numbers to be automatically populated like the above, you can add these special numbers to the custom sequence.

Click on the menu "Tools" "option", click the "Custom Sequence" tab in the pop-up dialog box, and then enter the custom serial number on the right, such as "A, B, C ...", click "Add" when you are done, and then click "OK" on the button.

After we set the custom ordinal number, we can use the method above to enter the first two ordinal number, and then select the input ordinal cell, drag to the last cell of the ordinal number can be automatically populated.

Automatic input Sequence number

Word has an automatic input sequence number function, in fact, in Excel also has this function, you can use the function to implement. Click the A2 cell to enter the formula: =if (b2= "", "", COUNTA ($B $2:b2)), and then move the mouse to the lower right of the A2 cell, the mouse becomes a cross, and drag and drop to fill the cell below column A, so that when we enter the column B, The ordinal number is automatically entered in column A.

Quickly enter complex serial numbers

Sometimes we need to enter a number of longer product serial number, such as 493948830001, 493948830002, 493948830003 ..., the previous numbers are the same, just follow the serial number of the following changes. We can also make fast input for such serial numbers.

Select the cells that you want to enter these complex numbers, click the menu "format" cell, click the "Number" tab in the pop-up dialog box, select "Customize" under the category, and then enter "49394883" 0000 "and click" OK "button.

Just enter 1, 2, 3 ... in the selected cell. Sequence number, it automatically becomes the set's complex sequence number.

Auto-Adjust ordinal number

Sometimes we need to hide some of the lines to print, but we will find that the serial number is not continuous, then need to let the sequence number automatically adjusted.

In the A2 cell, enter the formula: =subtotal ($B $2:b2), and then drag it to the cell below column A by using the method described above, which automatically adjusts the ordinal number.