ROW is an effective way to insert serial numbers in your Google Sheets.
It can return the row number of a reference and when you skip referring to any cell it will return the row number of cell in which you have entered it.
Here's the simple steps.
Quick Note: If you are not starting your serial numbers from row 1, you have to add the count of rows in the formula which you have skipped.
It has a benefit over other methods that it works even when you sort your data.
It can return the row number of a reference and when you skip referring to any cell it will return the row number of cell in which you have entered it.
Here's the simple steps.
- Go to cell A1 and enter the =ROW() formula in it.
- Now drag the formula to down, up to the serial number you want.
Quick Note: If you are not starting your serial numbers from row 1, you have to add the count of rows in the formula which you have skipped.
It has a benefit over other methods that it works even when you sort your data.
COMMENTS