Excel Max Index: Row, Column, and INDEX Function Limits

Formulas & functions · Updated November 18, 2026

In current Microsoft Excel for Microsoft 365, the largest worksheet row index is 1,048,576, and the largest column index is 16,384, labeled XFD. If you mean the INDEX function, its row and column numbers are positions within the range you give it, not necessarily worksheet row and column numbers.

Excel’s maximum worksheet dimensions

An Excel worksheet has 1,048,576 rows and 16,384 columns. The first cell is A1, and the bottom-right cell is XFD1048576. These limits apply to modern Excel workbook formats, including .xlsx, .xlsm, and .xlsb, and to Excel for Microsoft 365 on Windows. They are fixed grid boundaries, not settings you can increase.

The grid therefore contains 17,179,869,184 possible cell positions: 220 rows multiplied by 214 columns. That is a theoretical worksheet capacity, not a promise that a workbook can store or calculate billions of populated cells efficiently. Available memory, workbook size, formulas, formatting, and the computer’s resources can all impose practical constraints much earlier.

The maximum row and column indices are both one-based: row 1 is the top row, and column 1 is A. The last row is numbered 1,048,576; the last column is numbered 16,384. These numbers describe the grid. They do not mean every workbook uses those rows or that Excel automatically fills them with data.

How Excel column numbers map to letters

Excel displays column positions as letters rather than numbers. A is column 1, Z is 26, AA is 27, and the labels continue through three-letter combinations until XFD. The lettering is a base-26-style sequence without a zero symbol, so after Z comes AA rather than A0.

For example, column XFC is 16,383 and the final column, XFD, is 16,384. You may see the numeric position when using a formula such as COLUMN, while the grid itself continues to show the letter label. Knowing both forms helps when a question asks for an index rather than a cell address.

With the worksheet layout as the reference, the formula =COLUMN(XFD1) returns 16384. The row number in XFD1 does not affect that result; COLUMN reports the column position. Similarly, with the worksheet layout as the reference, =ROWS(A:A) returns 1048576, because the full column A contains that many rows. These are counts or positions, not estimates of the last row containing data.

What the INDEX function means by an index

The INDEX function returns a value or reference from a specified range. In its common array form, its arguments are an array, a row number, and an optional column number. The row and column numbers start at 1 and count from the top-left corner of that array. As a result, the index is relative to the range supplied to the function.

That distinction is the source of many confusing results. In INDEX(A5:C10,3,2), row index 3 means the third row of A5:C10, which is worksheet row 7. Column index 2 means the second column of that range, which is worksheet column B. The returned cell is B7, not the worksheet’s third row and second column.

If a range has three columns, a column index of 4 is outside that range even though the worksheet has thousands of columns. Likewise, if the array has six rows, a row index of 7 is invalid for that array even though the worksheet has more than a million rows. The maximum valid index for a particular INDEX call is generally the number of rows or columns in its supplied array.

In the array form, a row number or column number of 0 can request an entire column or row from the array rather than one cell. In Microsoft 365, a returned multi-cell array can spill into adjacent cells when the formula supports a dynamic array result and the destination cells are clear. If something blocks the output, Excel can show a #SPILL! error.

A concrete INDEX example

Suppose A2:C6 contains a small table, and cell B4 contains the number 42. With that layout, =INDEX(A2:C6,3,2) returns 42. The third row of the array begins at worksheet row 4, and the second column begins at worksheet column B, so the intersection is B4.

To interpret an INDEX formula reliably:

  1. Identify the exact range used as the array.
  2. Count rows from the range’s first row, starting at 1.
  3. Count columns from the range’s first column, also starting at 1.
  4. Check that the requested positions fit inside that range.

This method also explains why changing the range can change the result even if the row and column arguments stay the same. For instance, index 3, 2 means C3 when the array starts at A1, but it means B7 when the array starts at A5. The coordinates are local to each array.

Finding the last cell and navigating the grid

To go directly to the worksheet’s bottom-right cell, enter XFD1048576 in the Name Box, the small box to the left of the formula bar, and press Enter. You can also use Excel’s Go To command: on Windows, press Ctrl+G or F5, enter the address, and select OK. The Mac shortcut and dialog behavior can vary with keyboard settings, but the Name Box is a straightforward alternative there too.

Do not confuse the grid’s final cell with the last cell that contains information. Windows Ctrl+End moves to the last cell Excel considers used on a worksheet. That location can be far beyond the visible data if formatting or edits extended the used area. It can also differ from the last nonblank cell in a particular column. Ctrl+Down moves through a data region and may stop at a blank or at the edge of that region; it does not always jump to the worksheet’s last row.

When checking the true extent of a dataset, inspect the relevant column or range rather than assuming the worksheet boundary is the data boundary. This matters for printing, formulas that refer to whole columns, charts, and exported files. A sheet can have the full Excel grid even if it contains only a few hundred meaningful records.

Older Excel versions and file formats

Excel 2007 introduced the larger worksheet grid used by current Excel: 1,048,576 rows and 16,384 columns. The older Excel 97–2003 .xls format is limited to 65,536 rows and 256 columns, with IV as its final column. Saving a modern workbook in the older .xls format can therefore remove or make inaccessible data outside those older boundaries.

If a workbook must be shared with someone using an older Excel version or a system that requires .xls, check compatibility before saving. Excel may warn about features or data that the older format cannot preserve. Keeping a modern-format copy is prudent when the workbook uses rows beyond 65,536 or columns beyond IV.

Excel for the web uses the modern worksheet grid, though browser resources and feature availability can affect how comfortably a large workbook works. Excel for Mac also uses the modern grid for current versions. The key distinction is generally the workbook format and Excel version, not whether the computer is Windows or Mac.

Maximum grid size is not the same as a practical limit

Reaching the row or column boundary is uncommon in ordinary workbooks, but approaching it can make a file slow or cumbersome. Large ranges increase the amount of data formulas may need to inspect, and extensive formatting can enlarge a workbook’s used area. Whole-column references are convenient, but formulas that repeatedly process entire columns may do more work than formulas restricted to the actual data.

For example, a formula that searches A:A can refer to more than a million cells, even if the list has only 500 entries. In a small workbook this may be perfectly reasonable, but many complex formulas repeated across a large sheet can increase calculation time. Where practical, use a clearly bounded range or an Excel Table that expands as records are added. Choose the range based on the data, not merely on the worksheet’s maximum.

Rows and columns also have separate limits. A workbook cannot add a 1,048,577th row or a 16,385th column to the same worksheet. If a dataset exceeds a single sheet’s practical or fixed capacity, possible approaches include splitting it across worksheets or files, summarizing or filtering it, or using a database or another data tool designed for larger datasets.

Common misunderstandings about Excel max index

One frequent mix-up is between an index and a maximum value. The worksheet’s maximum row index is a position, while the MAX function finds the largest numeric value in supplied data. For example, a column might contain a maximum value of 980 even though its last populated row is 2,000. Those are different questions and require different reasoning.

Another mix-up is treating an INDEX argument as an absolute address. INDEX does not interpret row_num as the worksheet row number when you provide a smaller array. It counts from the first row of that array. A third misconception is that Ctrl+End always identifies the final nonblank cell in the data. It identifies Excel’s current used-range endpoint, which can be affected by formatting and past edits.

Finally, having a theoretical grid of billions of cells does not mean a file containing billions of populated cells will be practical. Cell capacity, calculation speed, memory, file size, and the structure of the data are related but distinct constraints.

Frequently Asked Questions

What is the maximum row number in Excel?
The maximum row number in a modern Excel worksheet is 1,048,576. It is the bottom row of the grid and appears in the address of the final cell, XFD1048576.

What is the last column in Excel?
The last column is XFD, which is column number 16,384. Column letters are labels for positions; XFD corresponds to the maximum column index.

What is the maximum index for Excel INDEX?
There is no single maximum INDEX argument that applies to every formula. Its row and column indexes are limited by the dimensions of the array or reference supplied in that formula. For a range with 10 rows and 4 columns, the ordinary single-cell positions run from row 1 to 10 and column 1 to 4.

Does INDEX use worksheet row numbers?
Not when you use a range as the array. It counts relative to the range’s top-left corner. In INDEX(A5:C10,3,2), the requested position is the third row and second column within that range, or cell B7.

How do I go to Excel’s last cell?
Type XFD1048576 into the Name Box and press Enter. This goes to the worksheet boundary; it does not tell you where your data ends. On Windows, Ctrl+End instead moves to the last cell Excel currently treats as used.

Why does an old Excel file have fewer rows?
A workbook saved in the Excel 97–2003 .xls format has a limit of 65,536 rows and 256 columns. Modern .xlsx, .xlsm, and .xlsb workbooks support the larger grid, so the file format can explain the difference.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.