Larger Worksheets
Over the years, perhaps the most common complaint about Excel was the size of a worksheet. A worksheet now has 1,048,576 rows and 16,384 columns, which works out to more than 17 billion cells, an Excel 2007 worksheet has more than 1,000 times as many cells as an Excel 2003 worksheet.
Excel 2003 versus Excel 2007
| Excel 2003 | Excel 2007 | |
| Number of rows | 65,536 | 1,048,576 |
| Number of columns | 256 | 16,384 |
| Amount of memory used | 1 Gbytes | Maximum allowed by Windows |
| Number of colors | 56 | 4.3 billion |
| Number of conditional formats per cell | 3 | Unlimited |
| Number of levels of sorting | 3 | 64 |
| Number of levels of undo | 16 | 100 |
| Number of items shown in the Auto-Filter dropdown | 1,000 | 10,000 |
| The total number of characters that can display in a cell | 1,000 | 32,000 |
| Number of unique styles in a workbook | 4,000 | 64,000 |
| Maximum number of characters in a formula | 1,000 | 8,000 |
| Number of levels of nesting in a formula | 7 | 64 |
| Maximum number of function arguments | 30 | 255 |
| Maximum number of function arguments | 30 | 255 |
MS Excel