How to automatically update the serial number of a row in Excel?

How to add a row of serial numbers in excel to automatically update: first open a sample workbook; then click on the cell "A3" where the serial number 1 is located, and enter "=row()-2"; finally fill in the formula That’s it.

How to automatically update the serial number of a row in excel:

1. Open an example workbook, and its serial number Column (Column A) is filled through drop-down;

2. Insert a new row between serial numbers 3 and 4 (pointed by the red arrow in the picture) (picture (pointed by the blue arrow in the figure), it can be seen that the serial number (pointed by the red arrow in the figure) is not updated accordingly;

3. To make the subsequent serial numbers automatically updated, To use the "row" function

Click on the cell "A3" where the serial number 1 is located (the red box in the picture), and enter "=row()-2"

The "2" here Indicates that the row number of the cell where the serial number is located (pointed by the blue arrow in the picture) is reduced by 1;

#4. Fill in the formula (red box in the picture);

5. Insert two more new lines. It can be seen that the serial number behind the inserted line (pointed by the red arrow in the picture) has automatically moved back one position;

6. Fill in the formula (red box in the picture), the effect is as shown in the picture below

Complete the setting of automatic serial number update

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to automatically update the serial number of a row in Excel?. For more information, please follow other related articles on the PHP Chinese website!