Excel ROW Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel ROW Function (Example + Sample File)

What is EXCEL ROW FUNCTION

The Excel ROW Function is listed under Microsoft Excel's Lookup Functions category. It returns the row number of the referred cell. In simple words, with ROW function you can get the row number of a cell and if you don’t refer to any cell then it returns the row number for the cell where you insert it.

How to use it

To learn how to use the ROW function in Excel, you need to understand its syntax and arguments: 

Syntax

ROW([reference])

Arguments

  • reference: A cell reference or a range of cells for which you want to check the row number.

Notes

  • It will include all types of sheets (Chart Sheet, Worksheet or Macro Sheet).
  • You can refer to sheets even if they are visible, hidden or very hidden.
  • If you skip specifying any value in the function it will give you the sheet number of the sheet in which you have applied the function.
  • If you specify an invalid sheet name, it will return a #N/A.
  • If you specify an invalid sheet reference, it will return a #REF!.

Example

To master the ROW function we need to try it out in an example and below is one which you can try out:

In the below example, we have used the row function check the row number of the same cell where we have used the function.

In the below example, we have referred to another cell to get the row number of that cell.

You can use the row function to create a serial number list in your worksheet.

All you have to do is just enter row functions in a cell and drag it up to the cell you want to add serial numbers.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.