COLUMN Function
Tells you which column number a cell sits in.
Category
Lookup & Reference
Available in
All versions, Microsoft 365
Returns
A column number
Overview
COLUMN returns the column number of a reference: column A is 1, B is 2, and so on. =COLUMN(D5) returns 4.
Leave the reference out and it returns the column of the cell the formula is in — handy for building formulas that change as you copy them across.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| reference | Optional | The cell or range to check. If left out, the formula's own cell is used. |
Examples
Example 1 — Basic column numbers
Each formula below points at a different cell.
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =COLUMN(A1) | 1 |
| 3 | =COLUMN(F10) | 6 |
| 4 | =COLUMN(AA1) | 27 |
Example 2 — A counter that grows as you copy right
We want VLOOKUP to return column 2, then 3, then 4 as the formula is copied across, without editing each one.
- In the first copy, COLUMN(B1) returns 2.
- Copied one cell right, it becomes COLUMN(C1) and returns 3, and so on.
Common mistakes
- Expecting a letter. COLUMN returns a number. To get the letter, use =SUBSTITUTE(ADDRESS(1, COLUMN(), 4), "1", "").
- Passing several areas. COLUMN can't take a multi-area reference like (A1, C1) — it returns #REF!.
Notes
- Given a range in Microsoft 365, COLUMN spills one number for each column: =COLUMN(B1:D1) returns 2, 3, 4.
- Related functions: COLUMNS, ROW, ADDRESS, INDEX.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.