January 19, 2021

COLUMN function in Excel

In this lesson we will learn how the COLUMN function works in Excel. The COLUMN Function is used to get the column number of a cell reference. Like COLUMN(F4) will return 6 as the referred cell F4 is in the 6th column of the Excel Spreadsheet.

=COLUMN([reference])
  • reference – [optional] A reference to a cell or range of cells. If this argument is omitted, the COLUMN function then returns the column number of the cell in which the formula resides.

Let’s understand with a simple example. In the below Excel Spreadsheet we have added a range of cells(B2:D5) as reference argument of COLUMN function in cell E1.

=COLUMN(B2:D5)

It returned the column number as 2 which is column B in the specified range.

In below example we used COLUMN function in cell E3 without any argument. So it returned the column number of the current cell which is 5(column C is the 5th column in the Excel Spreadsheet).

You can also check here to understand how the COLUMN function works in Google Sheet.

You can also check here to understand how the COLUMNS function works in Google Sheet.

You can also check here to understand how the COLUMNS function works in Google Sheet.

You can also check here to understand how the ROWS function works in Excel.

You can also check here to understand how the ROWS function works in Google Sheet.

You can also check here to understand how the ROW function works in Excel.

You can also check here to understand how the ROW function works in Google Sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *