Last Updated on October 30, 2023 by Jake Sheridan
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:
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
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.
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
Hit enter to finish your formula and you’ll see the row number appear in the cell
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.
More ways to use rows in Google Sheets:
- Move A Row
- Delete Empty Rows
- Group Rows
- Change Row Height
- Make A Row Float
- How Many Rows Can Google Sheets Handle?
- Add A Row
- Highlight A Row
- Insert Multiple Rows
- Delete Every Other Row
- Delete Rows
- Alternate Row Colors
- Highlight Row Based On Cell
- Select Multiple Rows
- Sum A Row
- Sort Rows
- Resize Rows
- Merge Rows
- Remove Duplicate Rows
- Switch Rows
- Select Every Other Row
- Duplicate Rows