Back to Index

EXCEL 2010-2007 : NEW LIMITS

Limit Excel 2003 Excel 2007
Columns in worksheet 256 16'384
Rows in worksheet 65'536 1'048'576
Number of differents colors in workbook 56 4.3 billions
Number of conditional formats that can be applied to a cell 3 Up to the memory available
Sorting levels 3 64
Number of items displayed by a filter list (auto filter mode) 1'024 32'768
Nnumber of characters that a cell can display 1'024 32'768
Nnumber of characters in a cell that Excel can print 1'024 32'768
Number of unique cell styles in a workbook 4'000 65'536
Length of a formula (number of characters) 1'024 8'192
Levels inside a formula (a formula inside a formula ...) 7 64
Number of arguments for a formula 30 255
Number of characters for a cell whose format is "text" 255 32'768
Pivot tables : number of columns 255 16'384
Pivot tables : number of fields displayed in the Pivot Table Field List 255 16'384

© Copyright : Office Doc / Web development by Office Doc