Excel Column Alphabetical Order: A to XFD Explained

Excel’s worksheet columns are labeled A through Z, then AA through AZ, BA through BZ, and onward to the final column, XFD. The labels follow column numbers in a repeating base-26 pattern; they are not arranged by ordinary dictionary-style alphabetical sorting.

The Excel column sequence

In a new worksheet using Excel’s standard A1 reference style, the first column is A and the 26th is Z. Because Excel does not stop at Z, the next column is AA. The sequence then continues through AZ, BA, BB, and so on until ZZ; after ZZ comes AAA. In Microsoft Excel for Microsoft 365, the last available column is XFD.

Here are useful points in the sequence, with each number indicating the column’s position from the left:

A is column 1, and Z is column 26.
AA is column 27, and AZ is column 52.
BA is column 53, and ZZ is column 702.
AAA is column 703, and XFD is column 16,384.

Excel column letters identify positions, just as row numbers do. A cell reference combines the two: B3 means the cell in column B and row 3, while XFD1048576 is the worksheet’s bottom-right cell in current Excel versions.

Why columns continue after Z

Excel needs more than 26 columns, so it extends the labels with additional letters. The system is similar to counting in base 26, but it has no zero symbol in its labels: A represents the first position, not zero. This is sometimes called a bijective base-26 system. The detail explains why the sequence after Z is AA rather than A0 or BA.

One way to understand the pattern is to think of the letters as digits whose values run from 1 to 26. The first position uses one letter, A to Z. When that range is used up, a second letter is added. In practical terms, each letter combination corresponds to one column number, and the labels increase without gaps as you move from left to right.

The 16,384-column limit applies to each worksheet in current Excel versions, including Microsoft 365. For historical context, Excel 2003 and earlier worksheets had only 256 columns, ending at IV. A workbook created in an older format may therefore have different limits until it is saved in a newer workbook format.

How Excel maps letters to column numbers

Column names are not merely decorative headings; Excel maps each one to an integer. That mapping makes formulas, cell references, and navigation possible. For example, a formula referring to D5 uses column D’s position, 4, together with row 5. Inserting a column can change the displayed letters of cells to the right, while Excel normally updates formula references to keep them connected to the same data.

To calculate a column number from a label by hand, treat each letter as a value from 1 to 26 and multiply the earlier positions by powers of 26. For AZ, A is 1 and Z is 26, so the result is 1 × 26 + 26, or 52. For XFD, the equivalent calculation is 24 × 26² + 6 × 26 + 4, which equals 16,384.

A practical conversion method works in the other direction: subtract 1 from the number, divide by 26, use the remainder to select a letter from A to Z, and repeat with the quotient until it reaches zero. Subtracting 1 at each stage accounts for the fact that the labels have no zero digit. You rarely need to do this calculation manually, but it helps explain why labels such as XFD are valid and why the change from Z to AA occurs.

Convert a column number to letters with a formula

A formula can return the letters for a column number when you need to build a report, document an imported file, or inspect a position supplied by another calculation. In this example, cell A1 contains the column number 28. Enter the following formula in another cell:

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

The result is AB, because column 28 is the second column after Z. ADDRESS creates the cell address AB1 using row 1, the column number in A1, and the relative-reference setting 4; SUBSTITUTE removes the row number. The formula works in Microsoft 365 and does not require a newer dynamic-array function. Keep the input between 1 and 16,384 for a valid worksheet column.

If you only need to identify a column while working in the grid, a formula may be unnecessary. On Windows, Ctrl+Space selects the entire column containing the active cell, and the Name Box to the left of the formula bar displays the active cell reference. On Mac, Control+Space is the corresponding column-selection shortcut, though macOS keyboard settings may assign that combination to another input feature.

Convert column letters to a number

To turn a column label into its numeric position with a worksheet formula, put the label in A1. For example, if A1 contains AZ, use this formula in another cell:

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

The result is 52, because AZ is the 52nd column. INDIRECT builds a cell reference from the text AZ1, and COLUMN returns the position of that reference. The label must be a valid column reference; an invalid label produces an error. INDIRECT is also a volatile function, meaning Excel may recalculate it more often than a nonvolatile formula, so avoid using it unnecessarily in very large models.

This approach is useful for one-off conversions, but labels stored as text can be more awkward than ordinary cell references. If the goal is simply to find a value, functions such as XLOOKUP or INDEX and MATCH are usually better suited than converting a column label into a reference. XLOOKUP is available in Microsoft 365 and Excel 2021 or later; INDEX and MATCH are also options in older Excel releases.

Alphabetical order versus sorting worksheet data

A frequent source of confusion is the difference between Excel’s fixed column labels and the data inside columns. You cannot change the built-in worksheet labels so that the columns themselves run A, AA, AB, B, and so on. Excel keeps the physical column order A, B, C through XFD. However, you can sort a table’s contents alphabetically, or sort entire columns from left to right according to values in a row.

To alphabetize headers while moving the associated data with them, select the complete data range, including the header row and all relevant records. Then use Data > Sort, choose Options, select Sort left to right, and confirm. Back in the Sort dialog, choose the row containing the headers under “Sort by,” then choose A to Z. Menu wording can vary slightly by Excel build, but the left-to-right option is the key setting.

Take care to include every row that belongs with those headers. Sorting only the header cells would detach the labels from the values beneath them. Also check for blank columns or unrelated content in the selected range; the sort should cover the full block whose columns need to move together. For a normal list with field names across the top and records down the rows, the usual top-to-bottom sort is generally the right choice instead.

Column headings, references, and navigation

Excel normally shows lettered column headings above the grid. The letters are part of the interface; they are not values stored in row 1. Typing a heading such as “Region” into A1 creates text in a cell, while the fixed label A remains above that worksheet column.

Excel also offers R1C1 reference style, which displays row and column positions as numbers rather than using A, B, C labels in references. On Windows, the setting is under File > Options > Formulas, in the “Working with formulas” section; select or clear R1C1 reference style to switch. R1C1 changes how references appear, not the worksheet’s number of columns or the order in which they exist. In A1 style, a range might be written A1:C10; R1C1 style expresses positions relative to rows and columns instead.

When a task requires reaching a far-right column, the Name Box can take you directly to a cell such as XFD1: type the reference and press Enter. On Windows, Ctrl+G opens Go To, where you can enter the same address. This is often more dependable than scrolling horizontally through thousands of columns. A reference such as XFD1 identifies the destination; it does not create data there.

Common mistakes and edge cases

The most common misunderstanding is assuming that AA comes immediately after A because it is alphabetically close to A. In Excel’s actual column sequence, B through Z come first, and AA is column 27. Another mistake is treating the last letters as an unlimited range. Current Excel worksheets stop at XFD, so a formula that tries to create a reference beyond column 16,384 cannot point to a valid cell.

Other checks can prevent avoidable problems:

Confirm whether a number means a column position or a value stored in a worksheet cell. The number 28 means AB only when interpreted as a column index.
Check whether the workbook is in an old Excel file format if its worksheet appears to end at IV. Saving in a modern format may be needed to use the newer worksheet size.
When formulas change after inserting or deleting columns, inspect the references. Excel adjusts ordinary cell references in many cases, but text that merely contains a label, such as the string “C1,” is not necessarily treated as a live cell reference.
When sorting, select all related data rather than just the labels. Otherwise, headings and values can become mismatched.

These distinctions matter when reading documentation, building formulas, or sharing instructions with someone using a different reference style. The letters tell you where a column sits; they are not a separate alphabetic sorting rule applied to the worksheet.

Frequently Asked Questions

What comes after column Z in Excel?
Column AA comes after Z. It is followed by AB, AC, and the rest of the sequence through AZ; the next label is BA.

What is the last column in Excel?
In current Excel versions, including Microsoft 365, the last column is XFD, which is column 16,384. Excel 2003 and earlier used a smaller worksheet limit and ended at IV.

Is Excel column order the same as dictionary order?
No. Excel orders columns by their numeric positions: A, B, C through Z, then AA. A conventional text sort can place multi-letter labels differently, so it should not be used to infer worksheet positions.

How do I make my column headings alphabetical?
If the headings are data in a row and their entire columns should move with them, select the whole data range and use Data > Sort > Options > Sort left to right. Choose the header row and A to Z. This sorts your data, not Excel’s fixed worksheet labels.

Why does my Excel worksheet show numbers instead of letters?
The workbook may be using R1C1 reference style. On Windows, open File > Options > Formulas and change the R1C1 reference style setting. This changes how references and headings display; it does not change the column positions themselves.

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.