How to automatically update serial numbers in Excel_One function to do it

Is it difficult to automatically update the Excel serial number? PHP editor Baicao tells you today that it only requires a simple function! This article will introduce in detail the method of using this function to automatically update the serial number, allowing you to quickly master this practical skill.

1. First, we set the starting position of the serial number.

2. Delete the serial number and enter =row()-1

3. Finally, press Enter and a normal serial number will appear. Then we will directly Just drop down and fill all the cells. In this way, no matter how we delete the middle cell, the serial number will still remain normal.

#4. Of course, this method only applies to column numbers. If it is row numbers, then the formula is =COLUMN()-1, and other operations are the same.

Isn’t it very simple? Those friends who are still worried about the serial number should quickly try it. Don’t be stupid and re-fill it over and over again. .

The above is the detailed content of How to automatically update serial numbers in Excel_One function to do it. For more information, please follow other related articles on the PHP Chinese website!