Search

# Excel COLUMN Function | Formula Examples + FREE Video

## Excel COLUMN Function (Example + Video)

### When to use Excel COLUMN Function

Excel COLUMN function can be used when you want to get the column number of a specified cell.

### What it Returns

It returnsÂ a number that represents the column number of the specified cell. For example, =COLUMN(B4) would return 2, as B is the second column.

### Syntax

=COLUMN([reference]

### Input Arguments

• [reference] – An optional argument that refers to a cell or range of cells.Â If this argument is omitted, COLUMN function returns the column number of the cell in which the formula resides.

• If the reference is a range of cells, COLUMN function returns the column number of the left-most column in the specified range. For example, =COLUMN(B2:D10) would return 2 as the left-most column is B2 for which the column number is 2.
• If the reference is entered as an array, COLUMN function returns the column numbers of all the columns in that array.
• Reference can not refer to multiple references or addresses.
• COLUMN function can be particularly helpful when you want to get a sequence of numbers in a row. For example, enter =COLUMN() in cell A1 and drag it to the right. You will have sequence of numbers 1.2.3..

## Excel COLUMN Function – Video Tutorial

Related Excel Functions:

Other articles you may also like:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster