Related Function:

The COLUMN function returns the first column number within a supplied reference.

Syntax

=COLUMN([reference])

Arguments

Argument Description
[reference] An optional argument that specifies the Excel reference that you want to return the column number of

Note: If [reference] is omitted, the function returns the column number for the current cell, i.e. the cell that the function is entered into.

Examples

  A B C D E
1 Formula Result Formula Result Notes
2 =COLUMN() 1 =COLUMN() 3 [reference] is omitted, therefore, the COLUMN function returns the column number of the cell that the function is entered into
3 =COLUMN() 1 =COLUMN() 3
4 =COLUMN(G6) 7 =COLUMN(E2) 5