Quick, clean, and to the point

Excel COLUMN Function

Excel COLUMN function

The Excel COLUMN function returns the column number for a reference. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

Get the column number of a reference.
Return value 
A number representing the column.
=COLUMN ([reference])
  • reference - [optional] A reference to a cell or range of cells.
Usage notes 

Use reference to get column number of a reference.

  • Reference can be a single cell address or a range of cells.
  • Reference is optional and will default to the cell in which the COLUMN function exists.
  • Reference cannot include multiple references or addresses.

Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!

See details.

Thank you, and thank you so very much for your videos, they are sooooo helpful. - Elizabeth
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course