Excel Columns: How Many Are There in a Full Worksheet?

How-to basics · Updated November 18, 2026

A standard modern Excel worksheet has 16,384 columns, labeled A through XFD. That limit applies to Excel for Microsoft 365 and to Excel versions from 2007 onward; the final column is XFD.

The Short Answer: 16,384 Columns

Excel’s worksheet grid contains 16,384 columns and 1,048,576 rows. A cell is identified by combining its column label and row number, so the last cell in a full worksheet is XFD1048576. The column count is the same whether you use Excel for Microsoft 365 on Windows, Excel for Mac, or the current Excel for the web.

For most everyday tasks, you do not need to count the columns one by one. The labels run alphabetically from A to Z, then continue with two-letter combinations, eventually reaching XFD. If you only need the answer for a quiz or a quick check, remember: 16,384 columns, with XFD at the end.

How Excel Column Labels Work

Excel’s column labels look like letters, but they are a numbering system rather than ordinary alphabetic names. A through Z represent columns 1 through 26. After Z, Excel starts two-letter labels: AA is column 27, AB is 28, and so on. Once the two-letter combinations are used, the labels continue with three letters.

The system behaves like a base-26 count with no zero digit: A represents 1, B represents 2, and Z represents 26. For example, AZ is column 52 and BA is column 53. The final label, XFD, corresponds to 16,384 because X is 24, F is 6, and D is 4: 24 × 26² + 6 × 26 + 4 = 16,384. This is why XFD may seem like an unusual endpoint; it follows from the label system and the worksheet’s fixed size.

Column letters are useful because they make cell references compact and readable. In a formula such as B2, B identifies the column and 2 identifies the row. As a formula is copied, Excel can adjust those references, which is why understanding the column labels can help when working with formulas, data tables, and ranges.

How to Check the Column Count in Excel

If you want Excel to return the number of columns in the worksheet, use the COLUMNS function. With any blank cell available and no existing data layout required, enter =COLUMNS(A:XFD). The result is 16,384 because the reference includes every column from A through XFD, inclusive.

You can also verify the number by going to the last column. In Excel for Microsoft 365 on Windows, click the Name Box to the left of the formula bar, type XFD1, and press Enter. Excel selects cell XFD1, at the top of the final column. The Name Box is also available in Excel for Mac; Excel for the web provides a Name Box as well. This method is often easier than dragging the horizontal scrollbar across a wide worksheet.

To check how many columns are in a smaller range, count its endpoints inclusively. For instance, B through G contains six columns: B, C, D, E, F, and G. Excel’s COLUMNS function can count a selected range too, which is helpful when the range is large or when its size may change.

Finding the Last Column Without Confusing It With the Last Data

The last column in the worksheet is always XFD, but the last column containing your data can be much earlier. A workbook might use only columns A through H, for example, while still having the full worksheet grid available. These are different questions: one asks for Excel’s maximum grid size, and the other asks where the current content ends.

Keyboard navigation can help locate data, but it does not always identify the worksheet boundary. On Windows, Ctrl+Right moves across a row to the edge of a contiguous data region, or to the worksheet edge when there is no further data in that direction. If there are gaps or additional blocks of data, the result may not be the last populated column in the whole sheet. Similarly, Ctrl+End moves to the last cell Excel considers used, not necessarily to XFD1048576. Formatting left behind in distant cells can also affect the used range.

For the actual grid boundary, enter XFD1 in the Name Box. For the last used cell, Ctrl+End on Windows is a useful starting point, but review the workbook if the selected cell seems unexpectedly far from the visible data. Excel for Mac has different keyboard conventions for some navigation shortcuts; using the Name Box avoids relying on a shortcut that may differ.

How the Limit Changed From Older Excel

Excel 2003 and earlier used a much smaller worksheet grid: 256 columns, ending at IV, and 65,536 rows. Excel 2007 expanded the worksheet to 16,384 columns and 1,048,576 rows. The modern column limit has remained the same in later desktop releases, including Microsoft 365.

This history explains why one workbook may appear to stop at IV while another continues to XFD. A workbook saved in the older .xls format can be opened in Compatibility Mode, where older format restrictions apply. Saving a copy in a modern format such as .xlsx generally makes the expanded grid available, but check whether the people or systems receiving the file need the older format before changing it. Keeping a separate copy is sensible when preserving compatibility matters.

  • Excel 2003 and earlier: 256 columns, ending at IV.
  • Excel 2007 and later: 16,384 columns, ending at XFD.
  • Modern worksheet row limit: 1,048,576 rows.

What the Column Limit Means for Real Workbooks

Most spreadsheets use only a small portion of the available 16,384 columns. The maximum is useful for wide datasets, but it is not a recommendation to place every field in a separate column. A dataset with hundreds or thousands of variables can become difficult to review, filter, print, and maintain even when it fits within Excel’s limit.

Column count is also only one part of workbook capacity. A file’s practical performance depends on factors such as the amount of data, formulas, formatting, volatile calculations, links, and the computer’s available memory. Reaching XFD is not required for a workbook to become slow, and having thousands of blank columns does not by itself mean every cell contains data. Excel creates a grid with a maximum size; it does not require you to populate it.

If a table is growing sideways, consider whether some fields belong in rows instead. For example, storing one measurement per row with a date and category can be easier to filter and summarize than adding a new column for every date. The right layout depends on the task, but a tidy table with clear headers usually makes sorting, filtering, and analysis more manageable.

Common Misunderstandings About Excel’s Columns

A frequent source of confusion is treating the last used column as the last possible column. If a report ends at column M, that does not mean the worksheet has only 13 columns; it means the visible data currently reaches M. There are still columns N through XFD available.

Another misconception is that the column letters work like a simple alphabet that ends at Z. They continue through combinations such as AA, AZ, and XFD. A third is that Ctrl+End always jumps to the bottom-right corner of the worksheet. It instead moves to Excel’s last used cell, which may be far from the grid boundary—or may appear unexpectedly distant if cells were previously edited or formatted.

Finally, having a large maximum does not guarantee that every workbook format or connected application handles the same grid. Older .xls files have older limits, and an import, export, or third-party program may impose its own restrictions. When sharing data, check the file format and the capabilities of the receiving application rather than assuming that every tool supports XFD.

Frequently Asked Questions

What is the last column in Excel?
The last column in a modern Excel worksheet is XFD, which is column number 16,384. The last cell at the bottom-right corner is XFD1048576.

Does Excel for Mac also have 16,384 columns?
Yes. Current Excel for Mac uses the same worksheet limit as modern Excel for Windows: 16,384 columns and 1,048,576 rows. Navigation shortcuts can differ between platforms, but the grid size does not.

Why does my Excel sheet end at IV?
IV is the last column in Excel 2003 and earlier, and it can also appear when a workbook is using the older .xls format or Compatibility Mode. Check the workbook format and the Excel version before concluding that the application has a smaller limit.

Does Ctrl+End take me to Excel’s last column?
No. On Windows, Ctrl+End usually selects the last cell Excel considers used in the worksheet. That may be well before column XFD, or it may be farther right than your visible data if cells in that area were previously used or formatted.

How many columns are there from A to Z?
There are 26 columns from A through Z, counting both endpoints. After Z, Excel continues with AA, AB, and further labels rather than starting a new worksheet.

Can I add columns beyond XFD?
No. XFD is the worksheet’s final column in modern Excel, so there is no column beyond it. If your data needs more fields, consider reorganizing the layout, splitting the data across related sheets or files, or using a database or data-analysis tool suited to the task.

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.