O'Reilly logo

Excel® 2013 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7. The Big Grid and File Formats

Word leaked out in 2004 that Microsoft would be increasing the number of rows in the 2007 version of Excel. Although at that time no one knew exactly how many rows, one thing was certain—the Excel file format would have to change. The old XLS file format was designed around cell addressing that would fit in a 216 address space, hence the limit of 65,536 rows.

Excel Grid Limits

The new grid in Excel offers 1,048,576 rows—that is, 220 rows—a sixteen-fold increase from 65,536 rows in Excel 2003. It offers 16,384 columns (that is, 214 columns), an increase from 256 columns in Excel 2003. Overall, the new grid provides for 17.1 billion cells on each worksheet.

You can now analyze more complex data sets. For example, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required