• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

COLUMN in Excel

January 31, 2022 by Andrew Childress
Column function in Excel

When working in Excel spreadsheets, it’s useful to reference the column that a given value is contained in. Here's how to use COLUMN in Excel.

When you work in Excel spreadsheets, it’s often useful to reference the column that a given value is contained in. But remember, spreadsheets can contain a vast number of columns. Rather than searching manually, Excel can quickly provide this information using a simple formula. Let’s learn how to use COLUMN in Microsoft Excel.

How to Use COLUMN in Excel

Before we use the COLUMN function in Excel, it’s useful to know how Excel counts columns. They count from left to right, beginning with column A. Column A is column 1, column B is column 2, column F is column 6, and so forth.

Imagine that you have a value in AZ350. You need to know what column number AZ is. Rather than counting across the columns manually, you can use Excel’s COLUMN function to instantly return the solution.

To use COLUMN, click into any empty cell in your worksheet. As with any formula, your first step is to type an = sign. This tells Excel that the cell contents will be formulas, rather than simple values.

Then, type COLUMN( to add the COLUMN function to your formula, which so far reads:

=COLUMN(

Column Excel

Next, you’ll need to enter your cell reference. Remember, here we need the column number where cell AZ350 is located. Type (or click on) cell AZ350:

=COLUMN(AZ350)

Column function in Excel

This completes your formula. Press Enter on your keyboard, and Excel will instantly return the column number for cell AZ350:

52.

Column formula in Excel

Consider the logic. Column A is column 1; column Z is 26. The next range in Excel is AA through AZ, repeating the alphabet a second time. With 26 letters in the alphabet, repeated twice over, you arrive at AZ being column 52.

As you can see, the COLUMN function is a quick and easy lookup that you can build in Excel rapidly.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to use constants in ExcelConstants in Excel
Next Post:Clear Contents in ExcelClear contents Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top