Free Online Tutorials on Spreadsheets

COLUMN function in Excel


The COLUMN function returns the column number against the given cell reference. For example, =COLUMN(B1) returns 2 which means B column is the 2nd column.



The COLUMN function has the following argument:

[reference] – Optional. The cell reference or a range of cell against which Excel returns the column number. If omitted, Excel assumes the reference of the cell where the function appears.


Note: When a range of horizontal cells is selected e.g. (E6:G7), Excel returns the number of the leftmost column.

For more examples and detail, visit Microsoft Office website.

Related Functions

ROWS function returns the number of columns in a reference or an array.

COLUMNS function uses to find out the number of columns in a selected array or reference.

Copyright © 2016 - 2019 | All Rights Reserved