What should I do if the excel table serial numbers are all 1? The solution to the problem that the excel table serial numbers are all 1

For Excel users, it may be confusing when all rows in the table have a serial number of "1". This problem is usually caused by the serial number not updating automatically. In order to solve this problem and get the line number accurately, please continue reading the detailed guide provided by php editor strawberry. This article will introduce step by step how to solve the problem of Excel table serial numbers being all 1, to help you easily solve the serial number problem.

The solution to the problem that the excel table serial numbers are all 1

method one:

1. We can see that when doing drop-down sorting, we find that the sequence is all 1.

2. At this time, we right-click the icon in the lower right corner and click "Fill in sequence".

3. You can see that after clicking, our numbers will automatically be formed in a sequence.

Method 2: Use IF function:

If there are other conditions next to the sequence number column (for example, only rows that meet certain conditions require a sequence number), you can use the IF function in combination with the ROW function to generate a sequence number.

Method 3: Use sequence filling:

1. Select the range in which the serial number needs to be filled.

2. In the "Data" tab, click "Fill" and select "Series".

3. In the pop-up dialog box, set "Column" to occur in the column, set the step size to 1, and set the end value according to your needs.

The above is the detailed content of What should I do if the excel table serial numbers are all 1? The solution to the problem that the excel table serial numbers are all 1. For more information, please follow other related articles on the PHP Chinese website!