An Excel column number chart maps column letters to their positions: A = 1, B = 2, and Z = 26; after Z, the labels continue as AA = 27, AB = 28, and so on, up to XFD = 16,384. Use the chart below for columns A through AZ, or use Excel’s COLUMN function to find the number for any column in your worksheet.
Excel column number chart: A to AZ
The table gives the first 52 Excel column labels and their numbers. The four pairs of columns let you scan several positions at once; read each number alongside the letter immediately next to it.
| Number | Column | Number | Column | Number | Column | Number | Column |
|---|---|---|---|---|---|---|---|
| 1 | A | 14 | N | 27 | AA | 40 | AN |
| 2 | B | 15 | O | 28 | AB | 41 | AO |
| 3 | C | 16 | P | 29 | AC | 42 | AP |
| 4 | D | 17 | Q | 30 | AD | 43 | AQ |
| 5 | E | 18 | R | 31 | AE | 44 | AR |
| 6 | F | 19 | S | 32 | AF | 45 | AS |
| 7 | G | 20 | T | 33 | AG | 46 | AT |
| 8 | H | 21 | U | 34 | AH | 47 | AU |
| 9 | I | 22 | V | 35 | AI | 48 | AV |
| 10 | J | 23 | W | 36 | AJ | 49 | AW |
| 11 | K | 24 | X | 37 | AK | 50 | AX |
| 12 | L | 25 | Y | 38 | AL | 51 | AY |
| 13 | M | 26 | Z | 39 | AM | 52 | AZ |
For quick reference beyond the table, these are useful boundary values: Z = 26, AA = 27, AZ = 52, BA = 53, ZZ = 702, AAA = 703, and XFD = 16,384. Excel worksheets have 16,384 columns, so XFD is the final valid column in current desktop Excel.
How Excel column numbering works
Excel uses letters for column headings, but each column also has a number. The numbering starts at 1, not 0. A is 1, B is 2, and each next letter adds one. After Z, Excel adds another letter and starts the final position over at A: AA is 27. The sequence then continues through AZ, BA, and eventually ZZ before moving to three-letter labels.
This resembles a base-26 system, but it is not ordinary base 26 because there is no zero symbol. Each letter represents a value from 1 to 26, rather than 0 to 25. That detail explains why familiar place-value shortcuts can give the wrong answer. For example, AA is not 26 plus 1 as a new zero-based digit; its value is 1 × 26 + 1 = 27.
For a two-letter label, the calculation is the first letter’s value multiplied by 26, plus the second letter’s value. So AZ is 1 × 26 + 26 = 52, while BA is 2 × 26 + 1 = 53. For a three-letter label such as XFD, the place values are 26², 26, and 1: 24 × 676 + 6 × 26 + 4 = 16,384.
Why Excel uses letters and when the number helps
Column letters are convenient for reading cell references such as B4 or XFD20. The corresponding numbers are useful when a task depends on a column’s position: a formula may need to report the location of a value, a data import may identify fields by index, or a person may need to check how far across a wide worksheet a particular field sits.
The letter and number are two ways of describing the same worksheet position. If a cell is in column D, its column number is 4 regardless of its row. D1, D20, and D1048576 are all in column 4. A full cell reference combines both coordinates: D20 means column 4 and row 20. This is separate from the order of fields in a table or the position of a column within a selected range.
Find a column number directly in Excel
In Excel for Microsoft 365 on Windows, enter the COLUMN function in a blank cell. For example, with the formula entered in any cell, =COLUMN(A1) returns 1. The referenced cell does not need to contain data. To check column XFD, use =COLUMN(XFD1); the result is 16,384.
You can also select a cell in the column you want to identify and enter =COLUMN() in another cell. With no reference supplied, COLUMN reports the number of the column containing the formula itself, not the currently selected cell. For that reason, supplying an explicit reference is less likely to cause confusion. The function is available in Excel for Microsoft 365 on Windows and Mac, and in Excel for the web; the formula syntax is the same.
To jump to a known column, click the Name Box to the left of the formula bar, type a cell reference such as XFD1, and press Enter. Excel moves to that cell, and the letter at the top of the worksheet shows the column label. The Name Box accepts a cell reference, not a column number by itself, so enter a full reference such as BA1 rather than 53.
Convert a column number to letters with a formula
If A2 contains a valid column number from 1 to 16,384, enter =SUBSTITUTE(ADDRESS(1,A2,4),"1","") in another cell. When A2 is 53, the result is BA. ADDRESS creates a cell address using row 1 and the column number in A2; its third argument, 4, requests a relative-style reference. SUBSTITUTE removes the row number, leaving the column letters.
This formula is useful when a system or calculation gives you numeric positions but you need Excel-style labels. Keep the input within the worksheet’s valid column range. A number below 1 or above 16,384 does not represent a worksheet column, and a cell containing text instead of a number may produce an error.
Convert column letters to a number
For Excel for Microsoft 365, put a valid column label such as XFD in A2, then enter =SUMPRODUCT((CODE(MID(UPPER(A2),SEQUENCE(LEN(A2)),1))-64)*26^(LEN(A2)-SEQUENCE(LEN(A2)))) in another cell. The result for XFD is 16,384. The formula reads each letter, turns it into a value from 1 to 26, and weights it according to its position. UPPER allows lowercase input such as xfd.
SEQUENCE is available in Microsoft 365 and Excel 2021 or later. This formula assumes A2 contains only a valid column label, with no row number or spaces. For example, enter XFD, not XFD1. If you only need to convert a single label and do not want a formula, use the chart’s boundary values or select a cell in that column and use COLUMN with a reference.
Worksheet limits and common mix-ups
Excel’s maximum worksheet size is 1,048,576 rows by 16,384 columns. Those limits mean XFD is valid, but later labels such as XFE are not worksheet columns. A calculation that produces a number higher than 16,384 may still be arithmetic, but that result cannot identify a column on an ordinary Excel worksheet.
Several easy-to-make mistakes are worth checking:
- Treating Z as the final column: Z is only column 26. Excel continues with AA and onward.
- Starting at zero: Excel’s first column, A, is 1. There is no column 0.
- Confusing a column number with a row number: In C25, C is column 3 and 25 is the row.
- Including a row in a label conversion: COLUMN letters are A, AA, or XFD; a full cell reference such as AA5 includes a row number too.
- Assuming a number is a range-relative position: COLUMN(A1) returns the absolute worksheet column number. If a table begins in column D, its first field is worksheet column 4, not 1.
That last distinction matters in formulas and data work. A position within a selected block and a worksheet column number are not necessarily the same. For a block beginning in D, its first column is the first position in that block but column 4 on the worksheet.
Using the chart with formulas and imported data
A column number can help make formulas respond to a cell’s position. For example, COLUMN(C1) returns 3, so it can be used as a numeric input where a formula needs the third worksheet column. If a formula is copied to the right, a relative reference such as A1 can adjust; the exact behavior depends on whether the reference is relative, absolute, or mixed. The chart itself does not change those reference rules.
Column numbers also appear in programming interfaces, data exports, and some spreadsheet instructions, where fields may be identified by position rather than by Excel’s letter headings. Before using a number from another system, confirm whether its indexing starts at 0 or 1. Excel worksheet columns start at 1, while other tools may use a different convention. An off-by-one mismatch can select the neighboring field even when the letters-to-numbers chart is correct.
Frequently Asked Questions
What number is column AA in Excel?
AA is column 27. Z is 26, so AA is the first column after Z.
What is the number for column AZ?
AZ is column 52. The next column, BA, is 53.
What is the last column in Excel?
The last column in a current Excel worksheet is XFD, number 16,384. The worksheet limit is 16,384 columns.
How do I find the column number of the current cell?
Use =COLUMN() in the cell whose own position you want to report. To check a different cell, provide its reference, such as =COLUMN(B7), which returns 2.
Does Excel column A have number 0 or 1?
A is column 1. Excel does not number worksheet columns from zero; the first column is A and the first row is 1.
Related
- Close Excel Shortcut Key for Windows and Mac
- Close Group Excel Shortcut: Close Workbooks and Rows
- Close Excel Shortcut: Windows and Mac Keys
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Combo Chart Bar Width: How to Change Gap WidthTo change bar width in an Excel combo chart, select a column series, open Format Data Series, and…
- Excel Pivot Table: Move a Row Field to Column LabelsTo move a row field to columns in an Excel PivotTable, click inside the PivotTable, open PivotTable Analyze…
- Nested Pie Chart in Excel: Create and Format a SunburstTo make a nested pie chart in Excel for Microsoft 365 on Windows, arrange your categories in separate…
- How to Add a Formula to an Excel GraphTo add a formula’s results to an Excel graph, enter the formula in a worksheet column, fill it…
- Excel Waterfall Chart Total Column: How to Add OneTo make a column a total in an Excel waterfall chart, select that individual column, right-click it, and…
- How to Make a Line Graph in Google Sheets: A Clear GuideTo make a line graph in Google Sheets, arrange your data in columns with time or category labels…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.