Excel COLUMN Function

What is COLUMN function in Excel?

The COLUMN  function is one of the Lookup & reference functions of Excel.

It Returns the column number of a reference.

We can find this function in Lookup & reference category of the insert function Tab.

How to use COLUMN function in excel

  1. Click on an empty cell (like F5 ).
an empty cell in excel

2. Click on the fx icon (or press shift+F3).

 the fx icon in excel

3. In the insert function tab you will see all functions.

the insert function tab in excel

4. Select Lookup & reference category.

5. Select COLUMN function.

6. Then select ok.

excel COLUMN function

7. In the function arguments Tab, you will see the COLUMN function.

8. Reference is the cell or range of contiguous cells for which you want the column number.

9. For example If you click on G4, see result= 7.

excel COLUMN function example

10. If you click on A4 , see result =1.

How to use COLUMN function in excel

11. You will see the result in the formula result section.

Examples of COLUMN function in excel

Examples of COLUMN function in excel

COLUMN related functions 

Leave a Reply

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