In the Insert Sequence Number dialog box click New button to expand the dialog. In the first cell of the range that you want to number type ROW A1. Click the cell with the number to select it hold down the Ctrl key on your keyboard then click.
Then select Series from the popup menu that automatically displays.
Select them and look out for a hair-cross in the bottom right corner. In the first cell of the range that you want to number type ROW A1. How to create sequential number in Excel FAST. Select them and look out for a hair-cross in the bottom right corner.