Skip to content

COLUMN

Lookup & referenceExcel 2007

The column number of a reference (or of the formula cell).

Syntax

COLUMN([reference])

Examples

=COLUMN()-COLUMN($B$1)+1

→ 1,2,3… across from column B

Related functions

ROWCOLUMNS

More Lookup & reference functions

ADDRESSAREASCHOOSECOLUMNSFORMULATEXTGETPIVOTDATAHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCH

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.