How to increase the drop-down sequence number in excel

php editor Xiaoxin introduces to you the method of increasing the drop-down serial number in excel. When using an excel table, sometimes we need to mark a certain column of data with an incremental serial number. At this time, we can quickly achieve this through the drop-down fill function. The method of adding drop-down serial numbers is simple and easy to understand, allowing you to easily complete data processing and improve work efficiency. Next, let us learn more about how to increase the drop-down serial number in Excel!

1. First, enter 1 and 2 in the first and second rows of the table, as shown below.

#2. Then select the two tables where you enter the numbers, as shown in the figure below.

3. After selecting, move the mouse pointer to the lower right corner of the table with 2 (remember not to click the mouse, but move the cursor there.) Move the mouse pointer to the lower right corner After that, wait until the cursor changes to a "ten" shape, and then click the mouse to pull down. After pulling down, you can see that the serial number is in increasing mode.

I’ve introduced to you how to increase the drop-down serial number in the excel table. It’s actually very simple. You can complete the increase of the drop-down serial number in three steps. You need to do it during the operation. Note that when the mouse is pulled down, the cursor in the lower right corner of the last line of numbers changes into a "cross" shape before the data can be pulled down. Otherwise, the data pulled down will be the same and not incremental.

The above is the detailed content of How to increase the drop-down sequence number in excel. For more information, please follow other related articles on the PHP Chinese website!