Column Function

In Excel, the Column function returns the column number of a cell reference.

The syntax for the Column function is:

Column( reference )

reference is optional. It is a reference to a cell or range of cells.

Note:

If the reference parameter is omitted, then the Column function assumes that the reference is the cell address in which the Column function has been entered in.

 

For example, the Column function used in the picture above returns 1 because the Column function has been entered in cell A1. Therefore, it assumes the following formula:

=Column(A1)

Applies To:

• Excel 2010

For Example:

Let's take a look at an example:

=Column(B4)	would return 2
=Column(B4:B6)	would return 2