How to use the ROW and COLUMN functions – Knowligent
How to use the ROW and COLUMN functions

How to use the ROW and COLUMN functions

HomeHow to, TechHow to use the ROW and COLUMN functions

Excel's ROW function returns the row number of a reference. The COLUMN function returns the column number. The examples in this tutorial show you how to use these ROW and COLUMN functions.

What do these ROW/COLUMN functions do in my Excel formulas?

The ROW function is used to:

The COLUMN function is used to:

In an Excel worksheet, rows are numbered from top to bottom, with row 1 being the first row. Columns are numbered from left to right, with column A being the first column.