COLUMN function


COLUMN(cell) returns the zero-based column number of a cell or variable in the spreadsheet. The cell argument is optional and COLUMN() returns the column number of the cell in which the formula is used.

COLUMN() can be shortened to COLUMN.


When you enter COLUMN() in cell B5, the value 1 is displayed.

See also

This site uses cookies to store information on your computer. More info...