How to use Excel COLUMN Function

how to use excel column function

Quick Intro

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.

For example, if you refer to cell A3 it will return 1 in the result as A’s column number is one.

Syntax

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

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

Get Column 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 the below example, I have used column function create a header with serial numbers.

Heading Serial Number With Excel COLUMN Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have COLUMNS function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.