How To Make Google Spreadsheet Add Numbers

In this tutorial, you will larn 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 lot may take data tables that don't start at the top of your spreadsheet, and so using these built-in row numbers to reference rows in your data may be confusing.

If you desire to add row numbers for a given tabular array or range in Google Sheets, you tin practise so easily past post-obit these steps:

Step 1

You volition need an empty cavalcade in order to insert row numbers.

If y'all don't already take 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 alphabetic character header at the top of the data column and selecting the Insert ane Left choice

Footstep 2

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

The beginning is the divergence between the default row number and the row numbers we're calculation.

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

Step three

Once you know the desired offset, double click the first cell you want to insert row numbers into and blazon the post-obit formula: "=row()-seven", replacing the seven, with the offset you determined in Footstep 2

Stride 4

Hitting enter to finish your formula and yous'll see the row number appear in the cell

Step 5

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