How to automatically increment Excel table serial numbers. Teach you three methods and you can learn them in one go.

The Excel serial number automatically increments, saving time and effort! Is it time-consuming and laborious to add serial numbers manually? Don't worry! PHP editor Xinyi has compiled several methods for you to easily achieve automatic increment of Excel serial numbers. Continue reading this article to learn how to set up automatic ascending sorting and say goodbye to tedious manual operations!

1. Enter a number

In the excel table page, click on a table and enter any number.

2. Move the mouse to form a plus sign

Then move the mouse to the lower right corner of the table to form a plus sign.

3. Pull down

and then pull down the plus icon to automatically increment the serial number.

2. Fill in increments in a sequential manner

1. Click the table

in the excel table page , select a table and enter any serial number.

2. Form a plus sign

and then move the mouse to the lower right corner of the table to display a plus sign.

3. Click on the window

Hold down Ctrl, pull the plus sign down, stop pulling and click on the small pop-up window on the right.

4. Select fill in sequence

In the small pop-up window, click Fill in sequence to automatically increment the serial number.

3. Fill function increment

1. Enter numbers

In the excel table page, click A form, enter any number.

2. Select Fill

Then on the function page in the upper row, click Fill this function to pop up a window.

3. Enter the termination value

In the page of the window, click the sequence, enter the number you want to terminate in the termination value, and click OK. The serial number is automatically incremented successfully.

The above is the detailed content of How to automatically increment Excel table serial numbers. Teach you three methods and you can learn them in one go.. For more information, please follow other related articles on the PHP Chinese website!