| 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 |
