How to automatically fill in a string of information and import it into excel?

As shown in the picture, I want to insert a serial number in front.

2

Right-click the title of column A and select Insert to insert the serial number column in front.

three

Fill in the title "Serial Number" and enter: 1 in cell A2.

four

Select cell A2, move the mouse to the lower right corner of the cell, and the mouse pointer will change to "+"and drag it down directly.

five

After dragging, the values under all serial numbers become "1".

six

At this point, a small icon will be displayed on the side. Click the small icon.

seven

Select "Fill in Serial Number" and the serial number will be filled in automatically.

end

Method/Step 2

In cells A2 and A3, fill in 1 and 2 respectively.

Select cells A2 and A3.

In the same way, drag the+sign in the lower right corner to automatically fill in the serial number.