=COLUMN(D10) returns 4, because column D is the fourth column.


Syntax

COLUMN([reference])

The COLUMN function syntax has the following argument:

reference Optional. The cell or range of cells for which you want to return the column number.

If the reference argument is omitted or refers to a range of cells, and if the COLUMN function is entered as a horizontal array formula, the COLUMN function returns the column numbers of reference as a horizontal array.



Notes:

If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it. Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.



If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column.


If the reference argument is omitted, it is assumed to be the reference of the cell in which the COLUMN function appears.


The reference argument cannot refer to multiple areas.




Example






Need more help?





Want more options?



DiscoverCommunity



Explore subscription benefits, browse training courses, learn how to secure your device, and more.






Microsoft 365 subscription benefits




Microsoft 365 training




Microsoft security




Accessibility center


Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.






Ask the Microsoft Community




Microsoft Tech Community




Windows Insiders




Microsoft 365 Insiders
















Was this information helpful?

Yes No


Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.)

What affected your experience?


Resolved my issue

Clear instructions


Easy to follow

No jargon


Pictures helped

Other



Didn't match my screen

Incorrect instructions


Too technical

Not enough information


Not enough pictures

Other

Any additional feedback? (Optional) To protect your privacy, do not provide any personal information such as email address, phone number, product key, password, or credit card number.

Submit feedback

By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.


Thank you for your feedback!
×







What's new
Surface Pro
Surface Laptop
Surface Laptop Studio 2
Copilot for organizations
Copilot for personal use
AI in Windows
Explore Microsoft products
Windows 11 apps


Microsoft Store
Account profile
Download Center
Microsoft Store support
Returns
Order tracking
Certified Refurbished
Microsoft Store Promise
Flexible Payments


Education
Microsoft in education
Devices for education
Microsoft Teams for Education
Microsoft 365 Education
How to buy for your school
Educator training and development
Deals for students and parents
AI for education



Business
Microsoft Cloud
Microsoft Security
Dynamics 365
Microsoft 365
Microsoft Power Platform
Microsoft Teams
Microsoft 365 Copilot
Small Business


Developer & IT
Azure
Microsoft Developer
Microsoft Learn
Support for AI marketplace apps
Microsoft Tech Community
Microsoft Marketplace
Marketplace Rewards
Visual Studio


Company
Careers
About Microsoft
Company news
Privacy at Microsoft
Investors
Diversity and inclusion
Accessibility
Sustainability

English (United States)