When to use Excel COLUMN Function

Excel COLUMN function can be used when you want to get the column number of a specified cell.

What it Returns

It returns a number that represents the column number of the specified cell. For example, =COLUMN(B4) would return 2, as B is the second column.



Input Arguments

[reference] – An optional argument that refers to a cell or range of cells. If this argument is omitted, COLUMN function returns the column number of the cell in which the formula resides.

Additional Notes

If the reference is a range of cells, COLUMN function returns the column number of the left-most column in the specified range. For example, =COLUMN(B2:D10) would return 2 as the left-most column is B2 for which the column number is 2. If the reference is entered as an array, COLUMN function returns the column numbers of all the columns in that array. Reference can not refer to multiple references or addresses. COLUMN function can be particularly helpful when you want to get a sequence of numbers in a row. For example, enter =COLUMN() in cell A1 and drag it to the right. You will have sequence of numbers 1.2.3..

Excel COLUMN Function – Live Example

Excel COLUMN Function – Video Tutorial

Related Excel Functions:

Excel COLUMNS Function. Excel ROW Function. Excel ROWS Function

Other articles you may also like:

Row vs Column in Excel – What’s the Difference?