Return the number for a row of a given cell reference. Return the number of the row for the cell where the function is located in the worksheet. Return a series of numbers identifying the numbers of all rows where the function is located, when used in an array formula.
The COLUMN function is used to:
Return the number of the column for the cell where the function is located in the worksheet. Return the number for a column of a given cell reference.
In an Excel worksheet, rows are numbered top to bottom with row 1 being the first row. Columns are numbered left to right with column A being the first column. Therefore, the ROW function would return the number 1 for the first row and 1,048,576 for the last row of a worksheet. The syntax for the ROW function is: The syntax for the COLUMN function is: Reference (optional): The cell or range of cells for which you want to return the row number or column letter. If the reference argument is omitted, the following happens:
The ROW function returns the row number of the cell reference where the function is located (see row 2 in the examples shown above).The COLUMN function returns the column number of the cell reference where the function is located (see row 3 in the examples shown above).
If a range of cell references is entered for the Reference argument, the function returns the row or column number of the first cell in the supplied range (see rows 6 and 7 in the examples shown above). As with most Excel functions, the function can be typed directly into the active cell or entered using the function’s dialog box. Follow these steps to type a function into the active cell: The number 2 appears in cell B2 since the function is located in the second row of the worksheet. When you select cell B2, the complete function =ROW() appears in the formula bar above the worksheet. The number 6 appears in cell B5 since the cell F4 is located in the sixth column (column F) of the worksheet. When you select cell B5 the complete function =COLUMN(F4) appears in the formula bar above the worksheet. Since Excel Online does not have the Formulas tab of the ribbon, you can use the following method, which works in all versions of Excel. The number 6 appears in cell B5 since the cell F4 is located in the sixth column (column F) of the worksheet. When you select cell B5 the complete function =COLUMN(F4) appears in the formula bar above the worksheet.
