How to use
- On the Letter / number tab, type letters such as
ABto get 28, or a number such as28to getAB. The tool tells which one you typed. - On the Cell address tab,
AB12is split into row 12 and column 28. You can also type a row and a column number to build an address. Addresses with$such as$AB$12work too. - On the Range size tab,
A1:C10is counted as 10 rows by 3 columns, 30 cells. Whole-column (A:C) and whole-row (3:10) ranges work as well. - The Column list tab builds a table of numbers and letters for any span of columns and gives you a tab-separated copy you can paste into a sheet.
How a column letter becomes a number
Excel names columns with a 26-letter system. Unlike ordinary base 26 there is no letter for zero, so Z is followed directly by AA. To convert, multiply each letter value (A=1 … Z=26) by the matching power of 26 and add them up.
AB= 1 x 26 + 2 = 28XFD= 24 x 676 + 6 x 26 + 4 = 16,224 + 156 + 4 = 16,384
| Letters | Number | Note |
|---|---|---|
| A | 1 | First column |
| Z | 26 | End of single letters |
| AA | 27 | First two-letter name |
| AZ | 52 | |
| BA | 53 | |
| ZZ | 702 | End of two letters |
| AAA | 703 | First three-letter name |
| CV | 100 | Column 100 |
| XFD | 16,384 | Last column in Excel |
Excel limits
| Format | Max rows | Max columns | Last column |
|---|---|---|---|
| xlsx (Excel 2007 and later) | 1,048,576 | 16,384 | XFD |
| xls (Excel 2003 and earlier) | 65,536 | 256 | IV |
A whole sheet (A1:XFD1048576) holds 1,048,576 x 16,384 = 17,179,869,184 cells. A whole column (A:A) holds 1,048,576. A CSV file can contain more rows than that, but Excel stops reading at the limit.
Formulas that do the same inside Excel
- Letters to number:
=COLUMN(AB1)returns 28 - Number to letters:
=SUBSTITUTE(ADDRESS(1,28,4),"1","")returns AB - Size of a range:
=COLUMNS(A1:C10)returns 3 and=ROWS(A1:C10)returns 10
Google Sheets has the same functions with the same results.
Common mistakes
- Expecting a column after XFD. Names like XFE or ZZZ do not exist in xlsx. The tool reports them as out of range.
- Writing row before column. A cell address is always column letters then row number, such as C5.
5Cis not an address. - Mixing up R1C1 notation.
R12C28names the same cell with numbers. The cell tab reads only the usual A1 style. - Reversing the ends of a range. Excel reads
C10:A1as the same range asA1:C10, and so does this tool, which shows the corrected form.
Frequently asked questions
Which column number is AA in Excel?
- Z is 26 and AA comes right after it. AZ is 52 and BA is 53.
What is the last column in Excel, and what number is it?
In xlsx the last column is XFD, number 16,384. The old xls format ends at IV, number 256.
How many rows can an Excel sheet have?
1,048,576 in xlsx and 65,536 in xls. Larger data is better split across sheets or files, or kept in a database.
Which letters is column 100?
CV: C (3) x 26 + V (22) = 78 + 22 = 100. The column list tab prints the whole table for any span.
How do I count the cells in a range?
(last row - first row + 1) x (last column - first column + 1). B2:D5 is 4 rows by 3 columns, so 12 cells. Both corner cells are included.
Can I type lowercase letters?
Yes. ab12 is read as AB12, and Excel formulas ignore case as well.
Is what I type sent to a server?
No. Everything is calculated in your browser and nothing is sent to a server.
Related tools
- Open and reorder sheets in the Excel and CSV workbench.
- Spread one cell over several columns with Split Column.
- Match two tables on a key column with Excel VLOOKUP Match.
- Reorder rows with Excel Sort and Filter.
What you type is processed only in your browser and is never sent to a server.