HomeExcel Functions ► Excel COLUMN Function

Syntax For Excel COLUMN Function

What is the use of Excel COLUMN Function?

Use Excel COLUMN Function to get the column number of a reference. In simple words, it will return a number which represents the column number of the reference.

Syntax for Excel COLUMN Function

COLUMN(reference)

reference A cell reference for which you want to get the column number.

More Information on Excel COLUMN Function

  • You cannot refer to multiple references.
  • If you refer to an array, column function will also return the column numbers in an array.
  • If you refer to a range of more than one cell, it will return the column number of the leftmost cell. For example, if you refer to the range A1:C10, it will return column number of the cell A1.
  • You skip to specify a reference, it will return the column number of the current cell.

Examples to understand Excel COLUMN Function

Get Column Number With Excel COLUMN Function

In above example, I have used column function to the get the column number of the cell A1.

Heading Serial Number With Excel COLUMN Function

As I have already mentioned, If you skip specifying cell reference it will return the column number of the current cell. In above example, I have used column function create a header with serial numbers.

Download Sample File

Download Sample File To Learn Excel COLUMN Function

More Tips Related With Excel COLUMN Function

Conclusion

Use Excel COLUMN Function to get the column number of given reference. Learn more about COLUMN from here.

Related Function

Columns | Rows | Row

Blog | Excel Functions