Things to Remember about the ROW Function in Excel =ROW(F7:G11) returns the row number of the topmost row in the specified range, i.e. after entering the reference argument (F7:G11) in row function, i.e. Here we are taking input reference as a range of cells, i.e. : is a cell or range of cells for which we want the row number. Let’s apply the ROW function in cell “G14”, Select the cell “G14” where the ROW Function needs to be applied.Ĭlick the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “row” in the search for a function box, ROW function will appear in select a Function box. It’s in a range of F7:G11 I need to find out the topmost row in the specified range (F7:G11) with the help of the ROW function. In the below-mentioned example, the Table contains student score in column F & their subject score in column G. When we apply the Row function for a specified range in excel, it will return the row number of the topmost row in the specified range let’s check out this here. 13.Įxample #3 – To Find out ROW Numbers for a Range of Cells =ROW(B13) returns the row number of that specified cell reference, i.e. after entering reference argument in row function, i.e. : It is a cell reference for which you want the row number. Double click on the ROW function.Ī dialog box appears where arguments for the ROW function needs to be filled or entered, i.e.

Let’s apply the ROW function in cell “C13”, Select the cell “C13” where the ROW function needs to be applied.Ĭlick the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “ROW” in the search for a function box, the ROW function will appear in select a Function box. In the below-mentioned example, the Data column contains “B13” in the cell B13 I need to find out the row number of that cell with the help of the ROW function. If you mention a cell reference with the ROW function, it will return the row number of that cell reference. 8.Įxample #2 – To Find out the ROW Number of the Specified Cell =ROW() without reference argument returns the row number of the cell where you entered row function, i.e. It is the cell that the row function is entered into). Here it is left blank, or this argument is not entered because we want the row number of the current cell (i.e. : (Optional argument) It is a cell reference for which you want the row number.

Text to rows in excel 2013