For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Lookup and reference

COLUMN Function

Returns the column number of a reference

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports



  • reference  Optional. The cell or range of cells for which you want to return the column number. If reference is omitted, COLUMN returns the column number for the cell in which the function appears. The reference argument cannot refer to multiple areas.

Applies To

Excel 2003 and above


You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's COLUMN function

Other Help


Charley's SwipeFile charts

Free Excel Dashboards