COLUMN

Returns the column number or numbers of the specified cell reference.

Syntax

COLUMN( [Reference r] ) → IntegerOrArray

Parameters

r

Optional. The cell or range of cells for which to return the column number.

Remarks

This function returns the number of a cell column. For example, the function returns 1 for column A, 2 for column B, and so on.

If r is omitted, the function returns the column number of the current cell. If r identifies a range of cells with width greater than 1, COLUMN returns an array containing the numbers of all columns included in the range. For example, COLUMN(A1:C2) returns the array {1, 2, 3}.

Example

Formula

=COLUMN()
=COLUMN(A1:C2)

See Also

Function Reference
ROW Function
SHEET Function