Maximum Limit of Rows, Columns etc in Excel

Submitted by Support on Sun, 02/07/2010 - 02:49

How BIG is Excel 2007 and 2010

If you have worked on a large set of data from a non-Excel data source, for example, MS ACCESS, there are chances that you would have stored that in multiple sheets.

This riducules the data management. Now in Excel 2007 and above you have a big Excel workbook with 16384 columns and 10,48,576 rows

Following table gives you how big Excel has grown :)

Excel 2003<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Excel 2007 and above

Maximum No of Rows

65,536

10,48,576

Maximum No of Columns

256

16,384