Excel Column Letters: How to Find or Convert Them Easily

How-to basics · Updated November 18, 2026

In Excel, a column letter is the label at the top of a worksheet column: A is the first column, Z is the 26th, AA is the 27th, and the final column in current Excel versions is XFD, number 16,384. To find a cell’s column letter, read the letter or letters before its row number in the cell reference—for example, the column in C5 is C.

What Excel column letters mean

Excel labels columns with letters so cell addresses can identify both a column and a row. A cell reference combines the column label and row number: B3 is in column B, row 3; AB12 is in column AB, row 12. The column heading appears above the worksheet grid, while row numbers run down its left side.

Letters are labels, not a display format that you can switch to ordinary numbers through a standard worksheet setting. Excel uses them as part of cell addresses and formulas. For example, =SUM(B2:B8) refers to a range in column B. The column’s numeric position is still meaningful behind the label: B is position 2, and AB is position 28.

A dollar sign can make a column reference absolute in a formula, as in $B$3, or lock just the column, as in $B3. It does not change the column letter or the cell’s location. When formulas are copied, these markers control which parts of the reference adjust.

How the sequence goes beyond Z

Excel continues the alphabetic labels after Z by adding another letter. The sequence begins A, B, C and continues through Z, AA, AB, AC, and so on. After AZ comes BA; after ZZ comes AAA. The system works like a base-26 count with no zero symbol: A represents 1 rather than 0. This is why ordinary base-26 conversion rules need adjustment to translate letters and numbers accurately.

  • A through Z are columns 1 through 26.
  • AA through AZ are columns 27 through 52.
  • BA is column 53, and ZZ is column 702.
  • AAA is column 703.
  • XFD is column 16,384, the last column in current Excel worksheets.

The pattern explains why the letters in a column label are not simply a number written in alphabetic form with A as zero. For instance, AA is 27, not 1 or 26. Each letter contributes according to its place, but because the labels start at 1, the calculation requires a one-step adjustment as the conversion moves between positions.

Find the column letter for a cell

If you already have a cell reference, the column letter is the portion before the row number. In E17, the column is E. In AD204, the column is AD. You can also select a cell and look at the Name Box, normally located to the left of the formula bar. It displays the selected address, such as AD204. The letters before the row number identify the column.

To select or inspect an entire column, click its lettered heading at the top of the grid. Excel highlights the column, and the heading makes its label visible. If headings are hidden, check the worksheet’s display settings: on Windows, open the View tab and make sure Headings is selected in the Show group. Excel for Mac also has worksheet heading controls on the View tab, though the ribbon layout can vary slightly by version. In Excel for the web, the column headings appear above the grid in the same way.

Be careful not to confuse a cell’s column label with the text or number stored inside it. A cell in column C might contain the word “January,” but its column is still C. Similarly, sorting or filtering rows does not rename the worksheet’s columns.

Convert a column number to its letter

A formula is useful when a number represents a column position and you need its Excel label. Suppose A1 contains the number 28. Enter this formula in another cell:

With the numeric column index in A1, this formula returns the corresponding letter label:

=SUBSTITUTE(ADDRESS(1,A1,4),"1","")

For A1 equal to 28, the result is AB. ADDRESS creates a cell address for row 1 and the specified column number; its final argument, 4, requests a relative reference without dollar signs. The result is AB1, and SUBSTITUTE removes the row number 1. For 16,384, the result is XFD. This method uses functions available in Excel for Microsoft 365 and does not depend on newer functions such as TEXTAFTER.

The input should be a valid whole-number column position from 1 through 16,384. Zero, a negative number, a decimal, or a number above the worksheet limit is not a valid column index and may produce an error or an unintended result. If your number is in a different cell, replace A1 with that cell reference. For example, if the number is in D2, use D2 in the formula.

Convert a column letter to its number

To go the other direction, enter a column label in a cell and ask Excel for the position of a reference in that column. Suppose B1 contains the text XFD. This formula returns its numeric position:

With a valid column label in B1, the formula below returns the column number:

=COLUMN(INDIRECT(B1&"1"))

For B1 containing XFD, the result is 16,384. The formula joins the label in B1 to the row number 1, creating the reference XFD1. INDIRECT turns that text into a reference, and COLUMN returns the reference’s position. The label must be a valid column label for the worksheet; extra spaces or other text can cause an error.

INDIRECT is a volatile function, meaning Excel recalculates it when the workbook recalculates. For a one-off conversion, that is often convenient. For a very large workbook with many such formulas, avoid adding unnecessary volatile formulas because they can increase recalculation work. If the label is already part of a cell reference, use COLUMN with that reference directly instead of constructing text.

Use COLUMN when you already have a cell reference

When the cell is known, COLUMN returns its numeric position without needing to extract letters from its address. With a reference such as C5, the formula is:

With the cell reference C5 as the argument, this formula returns 3:

=COLUMN(C5)

This can help build formulas that change according to their location. For example, a formula may use COLUMN to calculate an offset or identify the position of a heading. If the argument is omitted—=COLUMN()—Excel returns the column number of the cell containing the formula. In a formula entered in column D, the result is 4. When the reference points to a multi-column range, COLUMN can return an array of the column numbers in versions that support dynamic arrays; how that result displays depends on the formula and the Excel version.

To show a numeric column position next to a heading, you can also enter the number directly or use a formula based on a reference. The choice depends on whether the value should change when the formula is moved or copied. A direct number is fixed; COLUMN evaluates the position of the referenced or current cell.

Worksheet limits and older Excel versions

Microsoft Excel 2007 and later, including Microsoft 365, support 16,384 columns per worksheet, ending at XFD. Older Excel versions through Excel 2003 used a smaller grid with 256 columns, ending at IV. A workbook saved in an older file format may therefore have different worksheet limits or compatibility behavior. When exchanging files with older software, check the format and the recipient’s Excel version rather than assuming every workbook can use XFD.

The limit is per worksheet, not per workbook. A workbook can contain multiple sheets, and each sheet has its own grid. If a reference such as XFE1 appears in a formula, it is beyond the valid column range in current Excel and should be checked for a typo or a mistaken calculation.

Common mistakes and useful checks

  • Reading the row as part of the label: In AB12, the column is AB and the row is 12. The number is not part of the column name.
  • Assuming Z is the last column: Z is only the last one-letter label. Excel continues with AA and later labels.
  • Counting from zero: Excel’s first column is A, position 1. If a program or data source numbers columns from zero, add one before using the value as an Excel column number.
  • Using a label as a number: The text AA is not itself the number 27 in a worksheet calculation. Convert it to a reference or use a suitable conversion method first.
  • Misreading absolute references: In $AB$12, AB is still the column label and 12 is still the row number. Dollar signs affect copying behavior, not the address’s meaning.

When a conversion formula gives an unexpected answer, check the input type and range first. A number stored as text may behave differently from a numeric value, and a label with a leading or trailing space is not a clean reference. Also make sure you are interpreting a worksheet column position—not a table field name or a column number produced by another program with a zero-based system.

Frequently Asked Questions

What is the column letter for number 1 in Excel?

The first Excel column is A, so column number 1 corresponds to A. The second is B, and the 26th is Z.

What number is column AA?

AA is column number 27. There are 26 one-letter columns, A through Z, before the two-letter labels begin.

What is the last column letter in Excel?

In Excel 2007 and later, including Microsoft 365, the last worksheet column is XFD, which is column 16,384. Excel 2003 and earlier ended at IV.

How do I display a column letter with a formula?

If A1 contains a valid column number from 1 through 16,384, use =SUBSTITUTE(ADDRESS(1,A1,4),"1",""). For example, if A1 is 28, the formula returns AB.

Can I change Excel column letters to numbers on the sheet?

Excel does not provide a normal worksheet option that changes the column headings from letters to numbers. You can calculate a column’s position with COLUMN, or convert a number to a letter with a formula, but those results appear in worksheet cells rather than replacing the built-in headings.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.