TOROW Function Explained

The TOROW function in Microsoft Excel returns the row number of a reference. It takes a single argument, which is a reference to a cell or range of cells. It returns the row number of the first cell in the reference.

TOROW Function Syntax

The syntax for the TOROW function in Microsoft Excel is:

 
TOROW(reference) 

The function takes one argument:

  • reference: This is the cell reference or range of cells that you want to convert to a single row. The reference can be provided as a text string or as a cell reference. The argument can be a cell reference, a range of cells, or an array of cells.

The TOROW function converts a reference or range of cells to a single row. The function returns the values in the cells in the reference or range in a single row, separated by commas. If the reference or range contains multiple rows, only the values in the first row are returned.