Excel ROW function

The ‘ROW’ function in Excel will return the row number of a specified cell.

Note: if you wish to know the number of rows within a specified cell range, you will need to use the ROWS function instead.

Syntax

=ROW([reference])

Arguments

reference – input cell (i.e. the cell which you want to know the row number of)

Function category

Information

Returns

The ROW function will return the row number of a singular specified cell.

Download Excel File

 Example of ROW formula
error

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.