Excel COLUMN Function

Excel COLUMN Function


Get the column number of a reference.

Return value 

A number representing the column.


=COLUMN ([reference])


  • reference – [optional] A reference to a cell or range of cells.

Usage notes 

Use reference to get column number of a reference.

  • Reference can be a single cell address or a range of cells.
  • Reference is optional and will default to the cell in which the COLUMN function exists.
  • Reference cannot include multiple references or addresses.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas