The ROW function can be used to:

- 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
- when used in an array formula, the function will return a series of numbers identifying the numbers of all rows where the function is located

The COLUMN function can be 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 ROW and COLUMN Functions Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the ROW function is:

*= ROW ( Reference )*

The syntax for the COLUMN function is:

*= COLUMN ( Reference )*

**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 ROW function returns the row number of the cell reference where the function is located—row two above
- the COLUMN function returns the column number of the cell reference where the function is located—row three 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—rows six and seven above.

### Examples Using Excel's ROW and COLUMN Functions

The first example (row two above) omits the *Reference* argument and returns the row number based on the function's location in the worksheet.

The second example (row three above) returns the column letter of the cell reference (F4) entered as the *Reference* argument for the function.

As with most Excel functions, the function can be typed directly into the active cell (example one) or entered using the function's dialog box (example two).

### Example 1 - Omitting the *Reference* Argument With the ROW Function

- Click on cell
**B2**to make it the active cell - Type the formula
**=ROW()**into the cell - Press the
**Enter**key on the keyboard to complete the function - The number
**"2"**should appear in cell B2 since the function is located in the second row of the worksheet; - When you click on cell B2 the complete function
*=ROW ( )*appears in the formula bar above the worksheet.

### Example 2 - Using the *Reference* Argument With the COLUMN Function

- Click on cell
**B5**to make it the active cell - Click on the
**Formulas**tab of the ribbon menu - Choose
**Lookup and Reference**from the ribbon to open the function drop down list - Click on
**COLUMN**in the list to bring up the function's dialog box - In the dialog box, click on the
**Reference**line - Click on cell
**F4**in the worksheet to enter the cell reference into the dialog box - Click
**OK**to complete the function and return to the worksheet - The number
**"6"**should appear in cell B5 since the cell*F4*is located in the sixth column (column F) of the worksheet - When you click on cell B5 the complete function
*=COLUMN(F4)*appears in the formula bar above the worksheet