Excel Column Number to Letter Chart and Formula Guide

Charts & pivot tables · Updated November 19, 2026

In Excel, column 1 is A, 26 is Z, 27 is AA, and 16,384 is XFD. Use the chart below for columns 1–52, or convert a number in a worksheet with =SUBSTITUTE(ADDRESS(1,A2,4),"1","") when A2 contains the column number.

Excel column number to letter chart

This quick chart covers the single-letter columns and the first 26 double-letter columns. The number at the left of each pair corresponds to the letter beside it; for example, 34 maps to AH. Excel continues the same pattern beyond this range.

Number Letter Number Letter
1 A 27 AA
2 B 28 AB
3 C 29 AC
4 D 30 AD
5 E 31 AE
6 F 32 AF
7 G 33 AG
8 H 34 AH
9 I 35 AI
10 J 36 AJ
11 K 37 AK
12 L 38 AL
13 M 39 AM
14 N 40 AN
15 O 41 AO
16 P 42 AP
17 Q 43 AQ
18 R 44 AR
19 S 45 AS
20 T 46 AT
21 U 47 AU
22 V 48 AV
23 W 49 AW
24 X 50 AX
25 Y 51 AY
26 Z 52 AZ

Some useful later reference points are 53 = BA, 100 = CV, 702 = ZZ, 703 = AAA, 1,000 = ALL, and 16,384 = XFD. These examples help check a conversion or orient you when a worksheet extends well beyond the first few columns.

How Excel’s column labels work

Excel labels columns with a base-26-style sequence using the letters A through Z. It is similar to counting in a number system, but there is no zero digit in the labels. A represents 1, B represents 2, and Z represents 26. After Z, Excel adds a new letter position and begins at AA.

This missing zero is why the system is not ordinary base 26. In a conventional positional system, a two-digit number can begin with zero; Excel’s column labels instead move from Z directly to AA. After AZ comes BA, after ZZ comes AAA, and the letter combinations continue until the worksheet’s final column, XFD.

  • 1–26 use one letter: A through Z.
  • 27–702 use two letters: AA through ZZ.
  • 703–16,384 use three letters: AAA through XFD.

The labels are names for positions, not abbreviations of a number. For example, AA is not “A plus A”; it is the 27th column. Understanding that sequence makes it easier to spot an off-by-one mistake when translating between a column number and its label.

Convert a column number to letters with a formula

For a reusable conversion, put a whole-number column index in A2 and enter the formula in another cell, such as B2. With A2 containing 27, this formula returns AA:

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

ADDRESS builds a cell reference from a row number, column number, and reference style. Here, the row number is fixed at 1, A2 supplies the column number, and 4 requests a relative-style reference. ADDRESS therefore returns a text value such as AA1. SUBSTITUTE removes the row digit 1, leaving the column letters. For A2 = 1, the result is A; for A2 = 702, it is ZZ.

To use it for a list, enter your column numbers down A2:A10, place the formula in B2, and fill it down. In Excel for Microsoft 365 on Windows, you can drag the fill handle at the lower-right corner of B2 or copy and paste the formula into the cells below. The relative reference changes from A2 to A3, A4, and so on.

Use whole numbers from 1 through 16,384. A zero, a negative number, a decimal, or a number beyond the worksheet limit is not a valid column index and may produce an error or an unintended result. If the values come from imported data, check that they are numeric and within that range before relying on the output. The formula works in current desktop Excel for Windows and Mac, as well as Excel for the web; the conversion itself does not depend on a platform-specific feature.

Convert column letters back to a number

If B2 contains a valid column label such as XFD, enter the following formula in C2 to return its column number:

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

With B2 containing XFD, the formula constructs the reference XFD1 and returns 16,384. If B2 contains AA, the result is 27. The text in B2 must be a valid column label; a typo or an invalid reference causes an error. This conversion is useful when a report or a file export gives you letters but a calculation needs numeric positions.

INDIRECT turns text into a worksheet reference, which COLUMN can evaluate. INDIRECT is volatile, meaning Excel recalculates it more often than many ordinary formulas. For a few conversions this is generally manageable, but a workbook with very many such formulas may benefit from a different approach or from converting the values once and pasting the results. Always make sure the labels refer to columns available in the workbook’s Excel version.

Find a column number or letter in Excel

If you already have a cell and just need its position, Excel can supply the number without a chart. For example, enter =COLUMN(D5) in a worksheet cell and the result is 4, because D is the fourth column. The row number in the reference does not affect the result. With =COLUMN() entered in D5, Excel returns 4 for the column containing that formula.

To jump to a known location, use the Name Box at the left end of the formula bar: type a reference such as XFD1 and press Enter. You can also use Home > Find & Select > Go To, enter XFD1, and confirm. These methods take you to a cell; they do not convert a number into a label, but they are handy when you need to inspect a distant column quickly.

To identify a column visually, look at the letter above the grid. Selecting any cell in that column and using =COLUMN() in a temporary cell gives the matching numeric position. If you need the label from a cell reference as text for a report, the ADDRESS-and-SUBSTITUTE formula above is more direct than reading the column header manually.

Excel’s column limit and version differences

Excel worksheets in current Microsoft 365 versions have 16,384 columns, ending at XFD. That maximum applies to current Excel for Windows, Mac, and the web. The same conversion formulas work on these platforms; there is no separate Mac column alphabet or alternate letter chart.

Older Excel workbooks can have a smaller grid. Excel 2003 and earlier used 256 columns, ending at IV. A workbook saved in an older file format may therefore have compatibility limits even when opened in a newer Excel version. If a formula returns an error near the far edge of a sheet, check the file format and the version used to create or save it, as well as the number being converted.

The maximum is a worksheet boundary, not a recommendation to use every column. Very wide sheets can be difficult to navigate and maintain. For large datasets, a tidy table with clear field names is often easier to filter and analyze than a layout that spreads related data across hundreds of columns.

Common conversion mistakes

  • Counting A as zero: A is column 1, not column 0. This is the most common source of a one-column shift.
  • Assuming Z is the final column: Z is only the end of the one-letter labels. The next column is AA.
  • Treating letters as a simple two-digit code: After ZZ, Excel uses three letters, starting with AAA. The letter count grows when the prior sequence is exhausted.
  • Mixing up a column number and a cell address: 27 is a column index, while AA27 is a cell reference: AA is the column and 27 is the row.
  • Passing an invalid input: A blank, text string, zero, or out-of-range index is not a valid column position. Validate imported values before converting them.

A quick check catches many errors: confirm that 26 maps to Z and 27 maps to AA. If a formula gives Z for 27, it is likely using a zero-based convention or subtracting one unnecessarily. Excel’s worksheet columns are numbered from 1, so no adjustment is needed for the ADDRESS formula shown here.

Choosing between a chart and a formula

Use the chart when you need a quick one-off answer, are working away from a spreadsheet, or want to verify a familiar position such as 52 = AZ. A printed or saved chart is also convenient when formulas are not allowed in a workbook. For an occasional value above 52, the milestone examples and base-26 pattern can help, though a formula is less error-prone.

Use a formula when you have a list to convert, expect the input to change, or want the result to update automatically. The reverse formula is useful when column labels arrive as text and downstream calculations need numeric positions. If a workbook only needs to show a static list, copy the converted results and use Paste Special > Values to remove the formulas while keeping the labels. Keep the original inputs if you may need to refresh the conversion later.

Frequently Asked Questions

What column number is AA in Excel?
AA is column 27. Z is 26, so AA is the first two-letter column.

What is the last column in Excel?
The last column in current Excel worksheets is XFD, number 16,384. Older Excel versions, including Excel 2003 and earlier, ended at IV.

How do I get a column letter from a number in Excel?
With the number in A2, use =SUBSTITUTE(ADDRESS(1,A2,4),"1",""). For example, 27 returns AA. Enter a whole number from 1 to 16,384.

How do I get the number from a column letter?
If B2 contains a valid label, use =COLUMN(INDIRECT(B2&"1")). It returns 27 for AA and 16,384 for XFD.

Is the column number the same as the row number?
No. A cell reference such as C7 has column C, which is number 3, and row 7. COLUMN returns the column position; ROW returns the row position.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.