How to automatically fill in serial numbers:
1. Select the cell that needs to be filled with the starting serial number;
2. Enter the starting serial number "1 ";
3. Move the mouse to the lower right corner of the cell. When the cursor changes to a cross, hold down the Ctrl key on the keyboard, then hold down the left mouse button and drag downwards. In this way, the serial number will be filled in automatically.
Recommended tutorial:excel tutorial
The above is the detailed content of excel serial number autofill. For more information, please follow other related articles on the PHP Chinese website!