Automatically create serial numbers in Excel rows
Click in A1 cell and paste:
Then press Enter. The value of the cell will change to 1.
Then drag the cell from the corner all the way down or copy the first cell and press Ctrl+Shift+ down arrow. This will select the whole row. Then press Ctrl+V.