What is EXCEL COLUMN FUNCTION
The Excel COLUMN Function is listed under Microsoft Excel's Lookup Functions category. It returns the column number for the given cell reference. As you know, every cell reference is made up of a column number and a row number. So it takes the column number and returns it in the result.
How to use it
To learn how to use the COLUMN function in Excel, you need to understand its syntax and arguments:
- reference: A cell reference for which you want to get the column number.
- You cannot refer to multiple references.
- If you refer to an array, the 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 the column number of the cell A1.
- If you skip to specify a reference, it will return the column number of the current cell.
To master COLUMN function we need to try it out in an example, so make sure to check out the below one:
In the below example, we have used COLUMN to 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, we have used COLUMN to create a header with serial numbers.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL ADDRESS Function
- EXCEL AREAS Function
- EXCEL CHOOSE Function
- EXCEL COLUMNS Function
- EXCEL FORMULATEXT Function
- EXCEL HLOOKUP Function
- EXCEL HYPERLINK Function
- EXCEL INDEX Function
- EXCEL INDIRECT Function
- EXCEL LOOKUP Function
- EXCEL MATCH Function
- EXCEL OFFSET Function
- EXCEL ROW Function
- EXCEL ROWS Function
- EXCEL TRANSPOSE Function
- EXCEL VLOOKUP Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.