Column JJ is column number 270 in Excel. The quickest way to verify it in a worksheet is to enter =COLUMN(JJ1) in an empty cell; Excel returns 270 because the function reports the number of the column containing the referenced cell.
JJ at a glance
Excel assigns a number to every column, even though it displays column headings as letters. The first column, A, is 1; Z is 26; AA is 27. Continuing that sequence, JJ corresponds to 270. The letters are a label for a position, not a number written in ordinary base 26, so the second letter contributes to the count as well as the first.
Here are useful reference points around JJ:
- Column Z is 26.
- Column AA is 27.
- Column IZ is 260.
- Column JJ is 270.
- Column XFD, Excel’s last column, is 16,384.
This is useful when translating between a letter-based cell reference, such as JJ12, and a numeric column index used in a formula, a data export, or documentation. JJ12 means column 270 and row 12; the column number does not depend on which row is used.
How Excel numbers its columns
Excel’s column labels follow a sequence that resembles a base-26 counting system, but with an important difference: there is no zero symbol in the labels. A is the first position rather than zero, and after Z the labels continue as AA, AB, AC, and so on. This is sometimes described as a one-based or bijective base-26 system.
For a one-letter label, the number is straightforward: A through Z represent 1 through 26. With two letters, the first letter represents a group of 26 columns, and the second identifies a position within that group. Thus AA is one group of 26 plus one, or 27. The same principle extends to labels with three letters, such as XFD.
The letters do not reset the count at a new row. JJ1, JJ20, and JJ1048576 all belong to column 270. Their row numbers differ, but their column number remains the same. A cell address combines those two independent coordinates: the letters identify the column and the digits identify the row.
Why JJ equals 270
Each J has a value of 10 in the alphabetic sequence, where A is 1, B is 2, and J is 10. In the two-letter label JJ, the first J represents ten groups of 26 columns, and the last J adds ten more positions:
10 × 26 + 10 = 270
This also explains why treating JJ as the ordinary base-26 number 10 times 26 plus 10 happens to work here, while using a zero-based letter mapping can cause an off-by-one error. If A were treated as zero, the calculation would no longer match Excel’s labels. The safe convention is A = 1 through Z = 26, then apply the same rule to each letter position.
For a two-letter label XY, the general calculation is the value of X multiplied by 26, plus the value of Y. For JJ, both letter values are 10, giving 260 + 10. This calculation is handy for checking a result, but for a long label or a repeated task, letting Excel calculate the position is less error-prone.
Check the column number in Excel
In Excel for Microsoft 365 on Windows, you can use the COLUMN function. No particular data layout is required: enter the formula in any empty cell, and it refers to cell JJ1, which is in the column you want to check.
=COLUMN(JJ1)
The result is 270. The row number in the reference is only there to make a complete cell reference; using JJ5 or JJ100 instead would return the same column number. COLUMN returns a number, so Excel can use the result in arithmetic or another formula without converting the answer from text.
You can also locate the column visually. Click the Name Box, which sits to the left of the formula bar, type JJ1, and press Enter. Excel moves to that cell; the column heading JJ appears above the selected cell. This is useful when a worksheet is wide and the target column is off-screen. You can use the same method on Excel for Mac and Excel for the web, though the surrounding interface may look different.
If you only need to communicate the answer, no formula is necessary: JJ is 270. The formula is mainly useful when you want Excel to confirm a position or when a workbook needs to calculate column numbers dynamically.
How column numbers help with formulas and data
Column numbers matter because not every Excel feature uses letter labels. A worksheet displays references such as JJ3, but functions and external tools may identify a column by its position. Knowing that JJ is 270 makes it easier to interpret a numeric index, check a formula, or compare a worksheet layout with a data-processing specification.
For example, a formula that refers directly to JJ3 is easy to read when the column’s meaning is familiar. In a generic formula that selects a column by index, however, the number 270 may appear instead. If you see 270 in a column-index argument, it can refer to JJ, depending on the range that the formula uses. The index may be relative to that range rather than to the entire worksheet, so check what the formula treats as its starting point.
Column numbers are also useful when reviewing imported or exported data. A file format or script may describe a field as the 270th column, while Excel shows JJ at the top of the worksheet. Matching those representations can help identify whether a field has shifted because columns were inserted, removed, or reordered. The number alone does not tell you what the field contains; use the header and the surrounding data to confirm its meaning.
Common mistakes and misconceptions
- Counting A as zero: Excel starts at 1, not 0. A is column 1 and Z is column 26. This is the most common source of an incorrect conversion.
- Reading JJ as two separate column numbers: The label is a single column heading. It is not column J followed by another J, and it does not mean column 10.
- Confusing a column number with a row number: In JJ12, JJ identifies the column and 12 identifies the row. The column number is 270 regardless of the row.
- Assuming the worksheet has only 256 columns: That was the column limit in Excel 2003 and earlier. Current Excel versions have 16,384 columns, ending at XFD, so JJ is well within the worksheet.
- Using a relative range index as an absolute worksheet number: In some formulas, an index counts from the first column of a selected range. An index of 2 could mean the second column in that range, not worksheet column B. Read the range and the function’s definition before interpreting the number.
Another small source of confusion is the difference between the text JJ and a cell reference such as JJ1. JJ by itself names the column heading; a cell reference needs a row number as well. In formulas that expect a cell reference, use a complete reference. If a column label has been copied into a text field or stored as text, it will not automatically behave like a worksheet reference.
JJ compared with Excel’s column limit
JJ is far from the right edge of a modern Excel worksheet. Microsoft 365 worksheets support 16,384 columns, from A through XFD. Since JJ is 270, there are 16,114 columns after it, from JK through XFD. This context can be reassuring when a spreadsheet has many fields: JJ is a relatively early column in Excel’s full grid.
The 16,384-column limit is specific to modern Excel’s worksheet grid. If you are opening an old file created for Excel 2003 or an earlier version, its original grid limit was 256 columns, ending at IV. JJ is below that historical limit, but columns beyond IV may not be available in a workbook constrained to the older format. When working with legacy files, the file format and compatibility behavior can matter as much as the current Excel version.
Excel’s column limit is a maximum, not a recommendation to use every available column. Very wide worksheets can be difficult to navigate and review. If many related fields are spread across hundreds of columns, consider whether the data would be easier to maintain as a structured table with clearly named fields or split into related tables. The right arrangement depends on the task, but the number 270 itself does not signal a problem.
Frequently Asked Questions
What number is column JJ in Excel?
JJ is column number 270. Excel numbers columns starting with A as 1 and continues the sequence after Z with AA.
What formula gives the number of column JJ?
Enter =COLUMN(JJ1) in an empty cell. It returns 270. The reference can use another row in column JJ and still return the same answer.
Is JJ the 270th column or the 270th letter?
JJ is the 270th column in Excel. It is a two-letter column label, not the 270th letter of the alphabet; Excel’s column sequence continues beyond Z by combining letters.
What column comes after JJ?
JK comes next, so it is column 271. The last letter advances from J to K while the first letter stays J.
What is the last column in Excel?
In modern Excel, the last worksheet column is XFD, number 16,384. JJ, number 270, is well before that limit.
Does JJ mean the same column in every row?
Yes. Column JJ is column 270 in every row. For example, JJ1 and JJ500 are different cells, but both are in the same column.
Related
- Vendor Comparison Excel Template: A Practical Setup Guide
- Excel Drop-Down Validation: Setup, Lists, and Fixes
- Vacation Meal Planning Template Excel: Plan Every Day
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Color Duplicates in Google Sheets: Conditional FormattingTo color duplicate values in Google Sheets, select the cells, open Format > Conditional formatting, choose Custom formula…
- How to Average Data in Excel Across Different SheetsTo average the same cell across several worksheets, enter a formula such as =AVERAGE(Jan:Mar!B2) when the sheets are…
- Create Your Own PowerPoint Template for Free: A GuideYes—you can design a PowerPoint template without paying for a template file: use PowerPoint for the web with…
- Outlook: How to Stop Emails From Being Archived by AccidentTo keep messages in your Inbox, turn off AutoArchive in classic Outlook, remove Archive from Outlook on the…
- Excel Password Protect to Keep a Workbook from Opening?Yes. In Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect…
- How to Archive Emails in Outlook 365 Online EasilyTo archive emails in Outlook 365 online, select a message in your mailbox and choose Archive on the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.