COLUMN

Using the Excel COLUMN Function

Summary

The Excel COLUMN function is used to return the column number of a reference cell. For example, COLUMN (B4) would return 2 since column B is the second column in the worksheet. If a reference isn't provided, the function will return the column in which the function was entered.

The ROW function can be used if you need to find the row number of a reference cell.


Syntax

=COLUMN ([reference])

Syntax Breakdown

Reference
Optional. Reference can be blank, in which case the function returns the column in which it was entered, or you can specify a cell or range of cells.


Usage Notes

COLUMN returns the column number of a reference cell.

Entering a Range of Cells
If the reference argument is a range of cells and COLUMN is not entered as a horizontal array formula, the function will return the column number of the leftmost column.

Excel COLUMN with range of cells