How to automatically increment excel table serial number

There are three ways to automatically increment serial numbers in Excel: use the fill function, select the serial number cell, pull down to select the sequence, and the step size is 1. Using a formula, such as =ROW()-1, drag down to fill the series. Use the shortcut keys "Ctrl" and "D" to drag the selected serial number cell downward.

How to automatically increment the Excel table serial number

Method 1: Use the fill function

1. Enter the first serial number
2. Select the serial number cell and drag the mouse down to select the cell to fill the sequence
3. Click the "Home" tab Click the "Fill" button on the button and select "Sequence"
4. In the "Sequence" dialog box, select "Column" and enter the step size as "1"
5. Click "OK"

Method 2: Use the formula

1. Enter the formula in the cell where you want to place the first serial number: =ROW()-1
2. Drag the formula down to the cell where you want to fill the sequence

Method 3: Use the shortcut keys

1. Enter the first serial number
2. Select the serial number cell, drag the mouse downward to select the cell to fill the sequence
3. Press the "Ctrl" "D" shortcut key

Notes on usage

• When using the fill function, make sure the sequence is filled from the correct cell.
• When using a formula, make sure the number subtracted from the formula is the number of rows you want to subtract from the first row.
• When using shortcut keys, make sure the selected cell is the serial number cell.

The above is the detailed content of How to automatically increment excel table serial number. For more information, please follow other related articles on the PHP Chinese website!