This Excel tutorial explains how to use the Excel COLUMN function with syntax and examples.
The Microsoft Excel COLUMN function returns the column number of a cell reference.
The syntax for the COLUMN function in Microsoft Excel is:
COLUMN( [reference] )
The COLUMN function can be used in the following versions of Microsoft Excel:
The COLUMN function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel COLUMN function examples and explore how to use the COLUMN function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following COLUMN examples would return:
=COLUMN() Result: 3 (because the COLUMN function has been entered in cell C1, as per picture above) =COLUMN(C1) Result: 3 =COLUMN(B4) Result: 2 =COLUMN(B4:B6) Result: 2
(scroll to see more)