How to arrange the serial number of excel

First, use excel to open the data to be edited. For example, there are more than 20 pieces of data here.

Please click to enter a picture description.

Write 1 in the first cell of the serial number column, and position the mouse cursor in the lower right corner of the cell with the content of 1, and a+sign will appear.

Please click to enter a picture description.

Drag the mouse with the left mouse button until the end of the data line, then release the mouse, and you will find that the whole column serial number has become 1.

Please click to enter a picture description.

Don't panic, click on the small icon in the lower right corner and choose the filling order.

Please click to enter a picture description.

Then a miracle happened. No, this completes the automatic generation of serial numbers.

Please click to enter a picture description.

Then select the data center and adjust the format slightly to look good, so it's ok. Isn't it easy?

Please click to enter a picture description.