Tips for using serial numbers in an Excel worksheet

2. Auto-Input Serial Number
   When creating a table in Excel, you often need to enter the sequence number. However, in actual applications, there are many types of sequence numbers, some of which need to be expressed with special symbols, or even automatically input and adjust the sequence number, the following describes several tips about sequence numbers.
4. Enter the serial number
   In Excel, we can quickly enter some commonly used serial numbers, such as, 2 ...... A, B ...... January, February ......
   First, enter the first two of the sequence numbers, then select the cells where the two sequence numbers are located, move the mouse to the bottom right corner of the second sequence number, and you will find the mouse pointer in a cross shape, press and hold the left mouse button and drag it to the last cell of the input sequence number. Then, you can see that the sequence number has been automatically entered (1 ).
6. Custom special sequence number
   if you want to make some special sequence numbers automatically fill in as above, you can add these special sequence numbers to the custom sequence.
   click "Tools" and "options" in the menu, click the "Custom sequence" tab in the pop-up dialog box, and enter the custom sequence number on the right, for example, "a, B, c ......", Click "add" and then click "OK" (2 ).
   after setting the custom sequence number, we can use the above method to first enter the first two sequence numbers, and then select the cell that inputs the sequence number, drag to the last cell of the serial number to automatically fill it.
   auto-input sequence number
   word provides the auto-input sequence number function, which is also available in Excel. Click cell A2 and enter the formula = If (b2 = "", "", counta ($ B $2: B2). Then, move the cursor to the lower right of cell A2, the mouse turns into a cross shape. Press and hold the mouse to fill the cell below column A, so that when we input content in column B, column A will automatically enter the serial number (3 ).
8. enter a complex serial number quickly
   sometimes we need to enter a long product serial number, such as 493948830001, 493948830002, 493948830003 ......, The preceding numbers are the same, but the numbers are changed according to the sequence number. You can enter the serial number quickly.
   select the cells for which you want to enter these complex sequence numbers, click "format" and "cell" in the menu, and click the "Number" tab in the displayed dialog box, select "Custom (4)" under the category, enter "49394883" 0000 ", and click" OK.
   enter 1, 2, 3... in the selected cell ...... When the serial number is set, the complex sequence number is automatically changed.
   Auto Adjust sequence number
   sometimes we need to hide some rows for printing, but the result shows that the sequence number is not continuous. In this case, we need to adjust the sequence number automatically.
   enter the formula = subtotal (103, $ B $2: B2) in cell A2, and drag it to the cell in column A using the method described above, this will automatically adjust the serial number.