Column Z is column number 26 in Excel. The letters run from A as column 1 through Z as column 26; after Z, Excel continues with AA as column 27.
Why Z is the 26th column
Excel assigns each column a position starting at 1, then labels the positions with letters. The first 26 columns use the single letters A through Z, so counting from the start makes Z the 26th column. The column letter is a label, while the column number is its position from the left edge of the worksheet.
Here are some nearby examples to make the sequence clear:
- A is column 1.
- X is column 24, and Y is column 25.
- Z is column 26.
- AA is column 27, and AB is column 28.
- AZ is column 52, and BA is column 53.
So if a question asks what number column Z is, the answer is 26—not 25, and not a number based on the row you are looking at. Every cell in column Z has the same column number, whether it is Z1, Z100, or Z5000.
How Excel column labels work
Excel’s column labels use a letter-based counting system that resembles base 26, but it does not have a zero symbol in the way ordinary positional numbering does. In decimal, the digits are 0 through 9. In Excel’s column labels, A through Z stand for the 26 possible positions at each letter place, with A representing the first position rather than zero.
This is why the label after Z is AA, not A0 or another symbol. Once Excel has used all 26 single-letter labels, it begins two-letter labels. In that next group, AA is the first label and AZ is the 26th. The label BA follows AZ. The same pattern continues as the labels grow: ZZ is column 702, and AAA is column 703.
A useful way to think about it is to count the labels in order rather than trying to treat the letters as ordinary alphabetic initials. A is 1, Z is 26, AA is 27, and so on. The letter A in AA does not mean column 1 by itself; the complete label AA identifies one specific position in the worksheet.
How to check a column number in Excel
If you have Excel open, you can check the number with the COLUMN function. With no special worksheet setup required, enter the formula below in any empty cell. The cell reference Z1 is used because it is in column Z:
=COLUMN(Z1)
The result is 26. The row number in the reference does not affect the answer: =COLUMN(Z25) also returns 26 because Z25 is still in column Z. This is useful when you want Excel to provide the numeric position rather than count headers manually.
You can also select a cell in column Z and look at the lettered column heading above the grid. That heading tells you the column label, but not its numeric position directly. For a quick visual check, count the headers from A; for a repeatable calculation in a worksheet, COLUMN is the more convenient option.
Using COLUMN in formulas
COLUMN returns the number of the column containing a reference. If a formula refers to a specific cell, it reports that cell’s column position. For example, the formula with the reference Z1 returns 26 regardless of which cell contains the formula.
With the formula entered in cell Z1, the following version asks Excel for the position of the cell containing the formula:
=COLUMN()
In Z1, that formula returns 26. If you copy it to AA1, it returns 27; if you copy it to C1, it returns 3. This can help create headings or checks that depend on a formula’s location. Be aware that if you move or copy a formula, its result may change because the formula is now in a different column.
In formulas that refer to a range, COLUMN can return column positions for the referenced cells. The details of how an array of results is displayed can depend on the formula context and Excel version, so if you only need one position, use a single-cell reference such as Z1. The key point for this question stays simple: a reference to column Z has column number 26.
What comes after column Z
Excel does not stop at Z. It continues with AA, AB, AC, and onward. This is important when reading a formula, interpreting a table, or following instructions that refer to a column beyond the first 26. For example, a reference to AA1 points to the first row of the 27th column, immediately to the right of Z1.
Some useful checkpoints are:
- AA is 27, the first column after Z.
- AZ is 52, the last column in the group that begins with A.
- BA is 53, the next column after AZ.
- ZZ is 702.
- AAA is 703.
These examples can be especially helpful when you are reading a long formula or a worksheet with many fields. If a formula refers to XFD, for instance, that is not a three-letter label chosen at random: XFD is Excel’s final column in current worksheet versions, and it is column 16,384.
Column numbers and worksheet limits
In Microsoft Excel for Microsoft 365 on Windows, a worksheet has 16,384 columns, running from A through XFD, and 1,048,576 rows. The same column sequence applies in current Excel for Mac and Excel for the web. The number 26 is therefore a fixed position in the worksheet, not a setting that changes with the workbook or the computer.
Older Excel releases had smaller worksheet limits. Excel 2003 and earlier versions supported 256 columns, ending at IV, rather than the 16,384 columns available in modern Excel. If a workbook created in an older format is opened in a current version, its file format or compatibility settings may affect how its limits are handled. That historical difference does not change the fact that Z is column 26 in either system.
If you see a reference beyond XFD in a current worksheet, check whether it is a reference from another spreadsheet program, a text value, or part of a conversion issue. XFD is the last valid Excel worksheet column in the current grid; a column to its right cannot be selected as an ordinary worksheet cell.
Common mix-ups about column Z
A frequent mistake is to confuse a column number with a row number. In Z26, for example, Z identifies column 26, while 26 identifies the row. The cell is at the intersection of the 26th column and the 26th row. In Z1, the column is still number 26 even though the row is 1.
Another source of confusion is assuming the alphabet count starts at zero. Excel worksheet columns start at 1: A is 1, not 0. As a result, Z is 26. This is different from some programming conventions in which an array’s first item may be called index 0; Excel’s ordinary column numbering does not use that convention.
Also, letters that appear in a formula are not always column references. For example, text inside quotation marks or a named range can contain the letter Z without pointing to column Z. A cell reference such as Z1 is a column-and-row address; the isolated letter Z may simply be text, depending on where and how it appears.
Why Excel might show numbered columns
Excel normally labels columns with letters, but it can display row and column references in R1C1 style. In that mode, rows and columns are represented by numbers rather than the familiar A1-style column letters, so a heading may not visibly say Z. This changes how references are displayed, not the underlying position of the 26th column.
In Excel for Microsoft 365 on Windows, the R1C1 option is under File > Options > Formulas, in the section for working with formulas. Clear the R1C1 reference style checkbox to return to the usual lettered column headings. If you are looking at a workbook on another platform, the setting location can differ, but the column order and the fact that Z is number 26 remain the same.
Frequently Asked Questions
Is Z the 26th column or the 26th row?
Z is the 26th column. A row number is the numeric part of a cell address, so Z26 means column 26 and row 26.
What column comes after Z in Excel?
AA comes immediately after Z. Since Z is 26, AA is column 27, followed by AB as column 28.
How can I find the number for a column letter?
Use COLUMN with a cell reference in that column. For example, =COLUMN(Z1) returns 26. Replace Z1 with a reference to the column you want to check.
Does column Z have the same number in every worksheet?
Yes. In an ordinary Excel worksheet, Z is always column 26. The position does not change based on the sheet name, the selected row, or the data in the workbook.
Is Z also column 26 in Google Sheets?
Yes. Google Sheets also numbers its columns from A as 1, so Z is 26 and AA is 27. The broader spreadsheet limits and some features differ from Excel, but this basic column sequence is the same.
Related
- Subscript vs Superscript in Excel: What’s the Difference?
- Subscript in Excel: Shortcut Key and How to Apply It
- Excel Strikethrough Shortcut: Windows, Mac, and More
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: Count Checked and Unchecked CheckboxesTo count checked checkboxes in Google Sheets, use =COUNTIF(A2:A20,TRUE), assuming the checkboxes are in A2:A20 and use the…
- Excel Data Validation From a Named Range: How It WorksTo use a named range for Excel data validation, select the cells that need a drop-down, choose Data…
- Excel Cell Service in Clementi: What to CheckIf you mean a mobile-phone repair or service business called Excel Cell Service, I can’t reliably confirm that…
- Create a Distribution List in Outlook for Mac: StepsTo create a distribution list in Outlook for Mac, open People, choose New Contact List, name the list,…
- Excel Group Keyboard Shortcut: Rows and ColumnsIn Excel for Microsoft 365 on Windows, select the rows or columns you want to group and press…
- Change Date Format to Text in Excel: 3 Reliable WaysTo convert an Excel date into text while controlling how it looks, use the TEXT function, such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.