Click the cell with the number to select it hold down the Ctrl key on your keyboard then click the bottom-right corner. The ROW function returns the number of the row that you reference. Use the ROW function to number rows.
Enter 1 in a cell and enter 2 in a cell beside the first cell.
Here are the steps to use Fill Series to number rows in Excel. Insert unique sequence number in Excel as 1 2 3 Although there is not a command to insert sequence numbers in Excel you can insert sequence numbers in contiguous cells with clicking and dragging mouse. If you have a more specific task in mind then use the SEQUENCE function which is specially designed for this purpose. In the newly created chart click the Cumulative Sum data series orange bars in this example and right click to select Change Series Chart Type.