Written by Allen Wyatt (last updated January 25, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel includes a nifty little worksheet function that lets you determine the column number of a particular cell reference. Normally columns are designated as A, B, C, and so on, but the COLUMN function returns a numeric value that represents the column. Thus, column A is 1, B is 2, and so on.
You can use the function in the following manner:
=COLUMN(InputRange)
In this instance, the function returns the column of the range named InputRange. If InputRange contains more than one column then only the column number for the first column in the range is returned. You can also use the function without any optional range reference, as follows:
=COLUMN()
When used in this manner, COLUMN returns the column number of the cell in which the COLUMN function is used. Thus, if cell C5 contained =COLUMN(), then the function would return a value of 3.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2305) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using the COLUMN Function.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Normally the VLOOKUP function returns a value, and if it can't return a value it returns a zero. Here's how you can use ...
Discover MoreThe VLOOKUP function is very powerful, but it will only return values that meet a very limited set of criteria. If you ...
Discover MoreThe VLOOKUP function, like other lookup functions in Excel, is not case sensitive. In other words, it doesn't matter ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments