Quick Navigation
COLUMN Function
Summary
The COLUMN function returns the column number of a specified cell reference. This is essential for dynamic formulas, table structuring, and position-based calculations in Excel spreadsheets.
Syntax
COLUMN([reference])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| reference | Reference |
No | Optional cell reference. Returns leftmost column for ranges unless used in array formula. |
Using the COLUMN Function
COLUMN is perfect for creating flexible formulas that adapt to data position. Use it to generate dynamic headers, create position-aware calculations, or build self-adjusting tables.
Common COLUMN Examples
Basic Column Number
=COLUMN(D10)Returns 4 since column D is the 4th column.
Current Cell Column
=COLUMN()Returns the column number of the cell containing the formula.
Leftmost Column of Range
=COLUMN(B:E)Returns 2 (column B) as the leftmost column in the range.
Array Formula (Microsoft 365)
=COLUMN(B2:D2)Returns {2,3,4} as a dynamic array showing all columns in range.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Reference argument refers to multiple areas
Solution: Use single contiguous range only
Unexpected single number
Cause: Using range reference without array formula
Solution: Enter as array formula (Ctrl+Shift+Enter) or use Microsoft 365 dynamic arrays
Notes
- Column A=1, B=2, C=3, etc. (not letter-based)
- In array formulas, spills horizontally across columns
- Microsoft 365: Enter normally, gets dynamic array automatically
- Legacy Excel: Select range first, then Ctrl+Shift+Enter
- Cannot reference multiple separate areas
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+