## 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.

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.

## Sample File

## 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.

## Leave A Comment