How to set excel serial number auto-increment setting method

In excel, you can automatically increment the serial number by pulling down the first sequence in the table, which is very convenient. However, recently some users discovered that when using this function in Excel, the serial number will not be incremented and remains the same as the first one. How to solve it? The editor below will share with you how to set up the excel serial number that cannot be automatically incremented. Method 1 1. Open EXCEL and select cell A1 for drop-down filling.

2. After completing a filling, a filling option will appear next to it, click to expand.

3. Select [Fill Sequence] in the expanded list.

4. Just pull down again.

Method 2 1. Open the table and right-click on the cell that cannot be incremented. Select [Format Cells] in the pop-up menu. 2. Change the number category [Value] in [Number] to [General].

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