Following table summarizes the most important changes in Excel 2007.
| Sr No | Capability | OLD Limit | New Limit |
|---|---|---|---|
| 1 | Number of Rows | 65536 | 1048576 |
| 2 | Number of Columns | 256 | 16384 |
| 3 | Amount of memory used | 1 G bytes | Maximum Allowe by Windows |
| 4 | Number of colors | 56 | 4.3 billion |
| 5 | Number of conditional formates per cell | 3 | Unlimited |
| 6 | Number of levels of sorting | 3 | 64 |
| 7 | Number of levels of undo | 16 | 100 |
| 8 | Number of items shown in the Auto Filter dropdown | 1000 | 10000 |
| 9 | The total number of characters that can display in a cell | 1000 | 32000 |
| 10 | Number of unique styles in a workbook | 4000 | 64000 |
| 11 | Maximum number of charecters in a formula | 1000 | 8000 |
| 12 | Number of levels of nesting in a formula | 7 | 64 |
| 13 | Maximum number of arguments in a funtion | 30 | 255 |