Excel Column Letters vs Numbers: How References Work

How-to basics · Updated November 19, 2026

Excel uses letters to label columns in its standard A1 reference style, while numbers describe each column’s position: A is column 1, Z is 26, AA is 27, and XFD is 16,384. You can also switch a workbook to R1C1 reference style, which displays column numbers and writes cell references with row and column numbers.

What column letters and numbers mean

A worksheet is a grid: columns run vertically, and rows run horizontally. In the default A1 style, Excel labels columns with letters and rows with numbers. The first cell is A1, the cell at the intersection of column A and row 1. The next cell to its right is B1, and the cell below it is A2.

The letter is a column label, not a number written in a different font. But each label has a position in the sequence of columns. That position is useful in formulas, functions, charts, and automation. For example, the third column is C, so a formula can identify it either by its familiar letter or by its numeric position.

Excel’s grid has 16,384 columns and 1,048,576 rows in current versions. The last column label is XFD. These limits are the same whether you use A1 or R1C1 style; changing the reference style changes how Excel presents addresses, not the size of the worksheet.

How Excel maps letters to column numbers

The labels follow a base-26-like sequence, but the letters represent positions starting at 1 rather than the zero-based digits used in ordinary positional notation. After Z, Excel adds another letter and continues with AA, AB, AC, and so on. That is why AA is column 27, rather than column 26 or a label with a separate meaning.

  • A = 1, B = 2, and C = 3.
  • Z = 26, AA = 27, AB = 28, and AZ = 52.
  • BA = 53, ZZ = 702, and AAA = 703.
  • XFD = 16,384, the final column in a modern Excel worksheet.

For a two-letter label, you can work out its position by multiplying the first letter’s value by 26 and adding the second letter’s value. For example, AZ is 1 × 26 + 26, or 52. For labels with three letters, each position has a larger place value, and Excel’s sequence has a small adjustment because there is no zero-valued letter. In day-to-day spreadsheet work, you rarely need to calculate this by hand; Excel can return the position for you.

Column letters in A1 references

A1 is Excel’s default reference style. A cell address puts the column label first and the row number second: D8 means column D, row 8. In a formula such as =C2+D2, Excel reads the references as the cells in column C and column D on row 2. When a formula is copied, relative references normally adjust to the new location.

A dollar sign makes part of a reference fixed when you copy a formula. In $C$2, both the column and row are fixed; in C$2, only the row is fixed; and in $C2, only the column is fixed. These are still A1-style references. The dollar signs affect how a reference changes during copying, not the underlying column’s number.

Column letters are convenient because they are compact and easy to recognize in ordinary worksheets. They also appear in familiar tasks such as selecting a column by clicking its heading, reading a cell address in the Name Box, or referring to a range such as B2:F20. The letters are labels for the grid, though—not a substitute for the values stored in the cells.

R1C1 style: displaying columns as numbers

R1C1 is an alternative reference style in which R means row and C means column. In that style, the cell that A1 style calls C5 is shown as R5C3: row 5, column 3. Column headings are numbered rather than lettered, and references in formulas use the R-and-C notation. This can be helpful when you think of a worksheet as numbered positions or when comparing formulas copied across many columns.

In Excel for Microsoft 365 on Windows, turn it on through File > Options > Formulas, then select R1C1 reference style under Working with formulas. Clear the checkbox to return to lettered headings. On a Mac, look in Excel > Settings (called Preferences in some releases) and then General for the R1C1 reference-style option. Menu wording can vary slightly by release. In Excel for the web, the desktop setting may not be available, so use the desktop app if you need to change the workbook’s reference style.

R1C1 can express relative positions too. In a formula entered in a row, a reference such as RC[-1] means the cell in the same row, one column to the left. This kind of notation can make repeated formulas easier to compare, because the relative offset stays visible rather than changing from one lettered column to another. You do not have to use R1C1 just to find a column’s number, however; standard Excel functions can provide it while you keep the usual A1 view.

Find a column number or convert between styles

The COLUMN function returns a column’s position as a number. If the reference is C5, its result is 3, because C is the third column. The row number in the reference does not change the result.

With the cell reference C5 in the formula, enter =COLUMN(C5) in any worksheet cell; it returns 3. With no reference supplied, =COLUMN() returns the number of the column containing the formula. These can be useful when a formula needs to test or calculate based on a position rather than on a typed letter.

You can also turn a numeric position into a letter label using ADDRESS, which creates a cell address, and then extract the column part. Suppose A1 contains the number 27. With that layout, enter =RIGHT(ADDRESS(1,A1,4),LEN(ADDRESS(1,A1,4))-1) in another cell; the result is AA. ADDRESS constructs the relative address AA1, and RIGHT returns all of it except the final row digit. This example assumes a valid whole-number column position from 1 through 16,384.

To turn a label stored as text into a number, INDIRECT can interpret the label as part of a cell reference, and COLUMN can return its position. Suppose A2 contains the text AA. With that layout, enter =COLUMN(INDIRECT(A2&CHAR(49))); the result is 27. CHAR(49) supplies the character 1 to form the reference AA1. This approach depends on A2 containing a valid Excel column label and uses INDIRECT, which recalculates when the workbook changes; for a one-off lookup, switching to R1C1 or using COLUMN on an actual cell reference may be simpler.

When numbers are more useful than letters

Column numbers become especially useful when a task is based on position. For example, a formula may need to return the third column from a range, or a script may need to identify the column index of a field whose location can change. A number such as 3 is easier to pass into some functions than the letter C, because many Excel operations work with numeric row and column indexes.

Numbers are also useful when inspecting a formula pattern. In R1C1 notation, a formula that refers to the cell one column to the left can show the same relative relationship throughout a row. In A1 notation, formulas copied across the row might refer in turn to B2, C2, D2, and E2. Both styles can represent the same relationships; the more useful one depends on whether you want to see familiar addresses or relative offsets.

Letters remain the clearer choice for most people reading a conventional workbook, particularly when instructions say “enter this in column D” or when reviewing ranges. Numbers are often better for calculations, imported data structures, or code that needs an index. You can use numeric functions such as COLUMN without changing the display style for the entire worksheet.

Common mix-ups and troubleshooting

  • Confusing a column number with a row number: In A1, A is the column and 1 is the row. In R1C1, R1C3 means row 1, column 3.
  • Assuming AA is column 26: Z is 26; AA comes next and is 27. The alphabetic label sequence does not stop at Z.
  • Expecting a number to be the stored cell value: Column labels describe where cells are. The number returned by COLUMN is the position, not the contents of that cell.
  • Getting an error from a text label: A conversion based on INDIRECT needs a valid reference, such as AA1. Extra spaces, an invalid label, or a label beyond XFD can prevent it from working.
  • Seeing numbers after opening a workbook: The workbook may be using R1C1 style. Changing the reference-style setting restores lettered column headings; it does not change the data.

Also distinguish worksheet column letters from labels in a table. Excel tables use named headers such as “Date” or “Total,” and structured references may use those names rather than A, B, or C. A table’s first field might happen to be in column A, but its header text is not the column letter and can remain the same if the table moves.

Which style should you choose?

For a typical workbook shared with colleagues, A1 is usually the easiest style to read because most spreadsheet instructions, examples, and cell addresses use letters for columns. Keep it if you navigate by addresses such as F12, discuss ranges by their letters, or want your worksheet to look familiar to other Excel users.

Consider R1C1 if numbered columns better match your work, if you are comparing formulas by relative position, or if you routinely think in row-and-column indexes. It is a display and reference convention rather than a conversion of worksheet data. Excel can still work with the same cells and values after you switch styles, and you can switch back when needed.

If you only need a numeric column position occasionally, leave the workbook in A1 style and use COLUMN. If you only need a letter from a number once, the Name Box or an actual cell address may be enough; use a conversion formula when the task needs to repeat or update automatically. When sending instructions to someone else, state the style or give both forms—for example, “column C (column 3)”—to avoid ambiguity.

Frequently Asked Questions

What number is column AA in Excel?

AA is column 27. Z is column 26, so AA is the next label in Excel’s sequence.

What is the last column in Excel?

The last column in current Excel worksheets is XFD, which is column 16,384. The worksheet also has 1,048,576 rows.

How do I make Excel show column numbers instead of letters?

Enable R1C1 reference style. In Windows desktop Excel, use File > Options > Formulas and select R1C1 reference style. On Mac, check Excel > Settings or Preferences > General.

Does changing to R1C1 change my data or formulas’ results?

No. It changes how Excel displays row and column references, not the values stored in cells or the worksheet’s dimensions. Formulas may be shown using the alternative reference notation.

How can I get a column number from a cell reference?

Use COLUMN with a cell reference. For example, =COLUMN(C5) returns 3 because C is the third column; the row number does not affect that result.

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.