How To Number Rows In Google Sheets

In this tutorial, you will learn how to number rows in Google Sheets.

How To Number Rows In Google Sheets

Google Sheets automatically adds row numbers to the left of each row.

But sometimes you may have data tables that don’t start at the top of your spreadsheet, so using these built-in row numbers to reference rows in your data may be confusing.

If you want to add row numbers for a given table or range in Google Sheets, you can do so easily by following these steps:

Step 1

You will need an empty column in order to insert row numbers.

If you don’t already have one, insert a column to the left to the left of the data you want to add row numbers to by right clicking on the column letter header at the top of the data column and selecting the Insert 1 Left option

Step 2

Before entering the row number formula, we need to determine the correct offset to use in the formula.

The offset is the difference between the default row number and the row numbers we’re adding.

So if your data starts in row 8, subtract 1 from 8 to get an offset of 7.

Step 3

Once you know the desired offset, double click the first cell you want to insert row numbers into and type the following formula: “=row()-7”, replacing the 7, with the offset you determined in Step 2

Step 4

Hit enter to finish your formula and you’ll see the row number appear in the cell

Step 5

Select the cell with the formula and click on the square drag handle in the corner of the cell to drag the row number formula down as far as required

Your column will now contain row number formulas corresponding to the row within that data range/table, as opposed to the entire spreadsheet.

You can insert or delete rows within the table and the row numbers will automatically update.

Just be sure to update the offset number if the number of rows before the start of your data changes


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to number rows in Google Sheets. Want more? Check out all the Google Sheets Tutorials.