How to drag and fill serial numbers in EXCEL2021 Operation method

php editor Baicao introduces to you the operation method of dragging and filling serial numbers in EXCEL2021. In EXCEL, filling in serial numbers is a very common operation, which can quickly generate a series of consecutive numbers or other sequences. The drag-and-fill serial number function can help us save the tedious steps of manual input and improve work efficiency. Below, we will introduce in detail how to use the drag-and-fill serial number function to make your work more convenient and faster.

【Operation Method】

Step 1. Enter: 1 in the first cell under the serial number.

Step 2, enter 2 in the second cell, and then select the two cells.

Step 3. Select the point in the lower right corner and drag down to the cell you want to fill.

Step 4. This completes filling in the serial number.

The above is the detailed content of How to drag and fill serial numbers in EXCEL2021 Operation method. For more information, please follow other related articles on the PHP Chinese website!