The Excel COLUMN Function

Related Function:
ROW Function

Function Description

The Excel Column function returns the first column number within a supplied reference or the number of the current column.

The syntax of the Column function is:

COLUMN( [reference] )

where [reference] is an optional argument that specifies the Excel reference that you want to return the column number of. If the [reference] argument is omitted, the function returns the number of the current column (i.e. the column for the cell that the function is entered into).

Column Function Examples

The spreadsheet below shows six examples of the Excel Column function.

  A B C
2 =COLUMN( ) =COLUMN( ) =COLUMN( G2:H3 )
  A B C
1 1 2 5
2 1 2 7

Note that in the above example spreadsheet:

For further examples of the Excel Column Function, see the Microsoft Office website.