Excel limits for rows, columns, and cells in a worksheet

A modern Excel worksheet has 1,048,576 rows and 16,384 columns. Its final cell is XFD1048576, and multiplying the two dimensions gives 17,179,869,184 possible cell addresses. The amount of data you can store and calculate in a real workbook depends on its design and on available memory.

Find the last row and column

Rows run horizontally and have numeric labels. Columns run vertically and have letter labels. D3 is the intersection of column D and row 3.

  1. Open a blank .xlsx workbook in desktop Excel for Windows. Locate the Name Box to the left of the formula bar.
  2. Type A1048576 in the Name Box and press Enter to select a cell on the last row.
  3. Type XFD1 and press Enter to select a cell in the last column. XFD is column 16,384.
  4. Type XFD1048576 to select the cell at the intersection of the last row and last column.

1,048,576 × 16,384 = 17,179,869,184

Ctrl+End moves to the end of the used range, which can include formatting. To check the edge of the sheet itself, enter its exact address. The grid limit is per worksheet. The number of sheets in a workbook is subject to different constraints, including available memory.

Microsoft Support specifications and limits for Excel

The smaller grid in legacy .xls files

Excel 97–2003 .xls worksheets support 65,536 rows and 256 columns. The last column is IV. Saving a modern .xlsx as .xls can drop data outside the smaller grid and break formulas that reference those cells.

If someone needs the older format, keep the original .xlsx and use Save As to produce a separate copy. Review the Compatibility Checker before confirming. Changing the filename extension alone does not change the workbook format.

Microsoft Support guide to worksheet compatibility

Work with a CSV that exceeds the row limit

Suppose a CSV contains one header and 1,200,000 records. A worksheet can fit the header plus 1,048,575 records, leaving 151,425 records outside the grid. Keep the original file and avoid saving a truncated view over it.

To display only a subset, import with Power Query, then filter or aggregate before loading the result to a worksheet. If you need to summarize the full dataset, consider loading it into the Data Model and analyzing it with a PivotTable in a supported Windows version of Excel. Practical capacity depends on memory and model size. In a blank workbook, choose Data > From Text/CSV. In the preview, open the arrow next to Load, choose Load To, and select PivotTable Report.

Microsoft Support guidance on datasets too large for the grid

Store long identifiers as text

Excel’s numeric precision is 15 significant digits, a separate limit from worksheet dimensions. An ID like 001234567890123456 can lose its leading zeros and digits beyond the supported precision if Excel reads it as a number.

Set the cell format to Text before typing these IDs, or assign the column the Text data type at import before numeric conversion. Applying a text format after conversion cannot restore lost digits. Reimport from the original data if necessary.