And if you don’t give it any input argument, it will return the row number of the cell in which it is used. ROW function is Google Sheets gives you the row number of the cell reference you give to it. If you add more records to the dataset, you will have to the fill-down again do this to cover the new rows. Note: The result you get from this method is static. In case there is a blank record the dataset, double-clicking on the fill handle will only fill down the numbers till the filled record before the blank row. The above steps work when you have a continuous set of the dataset (i.e., there are no blank rows). You can then format this column to make it look better.
The above steps would give you serial numbers in the additional column you inserted. Double-click using the mouse (or left-click and drag till you want the numbers).The cursor would change into a plus icon (this is called the Fill Handle) Place the cursor at the bottom-right corner of the selection.Give the new column a heading and format it like other columns.To do this, right-click on any cell in column A and select ‘Insert Column’ Insert a column to the left the Name column.Suppose you have a dataset as shown below and you want to add serial numbers in column A.īelow are the steps to use the ‘Fill handle’ to fill down the serial numbers: If you have a dataset without any blank rows, this is the easiest way to add serial numbers. The method you choose to numbers rows will depend on how your data is structured or how you want this to work.įor example, if there are blank rows in between and you only want to add a serial number to records that are not blank, you can not use all the methods (example covered later in this tutorial). In this tutorial, I will show you four ways to add serial numbers in Google Sheets: