How to use COLUMN function in Microsoft Excel

In this article, we will learn about COLUMN function in Microsoft Excel.

COLUMN function returns the number of the current column where the function is located or the column number of a given cell reference.

COLUMN function has only one argument which is “reference”. It is a reference to a cell or range of cells for which you want to return the column number. If the reference is omitted, function assumes that the reference is the cell address in which the COLUMN function has been entered.

image 1


Let’s take examples and understand the applications of COLUMN function.

We have data in which we have taken 2 different types of examples; let’s have a look at the first example:-

image 2


In our first example, we will omit the reference argument and will tell the function to return the column number based on the function’s location in the excel sheet.

Follow the steps given below:-

  • Enter the function in cell D8
  • =COLUMN(), Press Enter

image 3


It returns 4 in cell D8 since the function is located in column D which is the fourth column of the worksheet.

2nd Example:-

In this example, we will return column number on the basis of the entered cell reference.

image 4


Follow the steps given below:-

  • Enter the function in cell D9
  • =COLUMN(F2), Press Enter

image 5


We get 6 as the column number since the cell F2 is in the sixth column of the worksheet. By changing the cell reference, column number will get changed accordingly.

So, this is how COLUMN function works in Microsoft Excel.


image 48


Video: How to use COLUMN function in Microsoft Excel

Click on the video link for quick reference to the use of COLUMN function. Subscribe to our new channel and keep learning with us!


If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at


Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube