Thursday, October 1, 2009

Some capabilities found in Excel 2007

The table below summarizes the expanded data storage and other capabilities found in Excel 2007.

Limit

Excel 2003

Excel 2007

Columns in a worksheet

256

16,384

Rows in a worksheet

65,536

1,048,576

Number of different colors allowed in a workbook

56

4.3 billion

Number of conditional format conditions applied to a cell

3

Limited by available memory

Number of sorting levels of a range or table

3

64

Number of items displayed in an AutoFilter list

1,024

32,768

Total number of characters displayed in a cell

1,024

32,768

Total number of characters per cell that Excel can print

1,024

32,768

Total number of unique cell styles in a workbook

4,000

65,536

Maximum length of a formula, in characters

1,024

8,192

Number of nested levels allowed in a formula

7

64

Maximum number of arguments in a formula

30

255

Number of characters that can be stored and displayed in a cell with a text format

255

32,768

Number of columns allowed in a PivotTable

255

16,384

Number of fields displayed in the PivotTable Field List task pane

255

16,384

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.