Microsoft 065-04940 - Office Excel 2007, User Manual

Page: 9 / 37

www.microsoft.com/office/excel 6
table and you need help choosing the right format, the Office Excel 2007 intuitive table
galleries show you how a table will look before you make your final selection.
Increased Spreadsheet Row and Column Capacity
Office Excel 2007 delivers greater spreadsheet capacity—1 million rows by 16,000
columns—to facilitate working with massive amounts of data. You no longer have to use
many different spreadsheets to support your data.
To support a bigger grid, Office Excel 2007 increases several other limits. For example,
the number of rows allowed in a PivotTable chart increased from 64,000 to over 1 million,
and the amount of memory that Excel can use increased from 1 GB to the maximum
allowed by Microsoft Windows
®
, while the limit on the number of rows of a column or
columns that can be referred to in an array formula was completely eliminated.
Faster Performance
To a large number of customers, the calculation speed of Excel is extremely important—
perhaps the most important “feature.” Calculations in large, formula-intensive
spreadsheets are now faster than before with the Office Excel 2007 support for dual
processors.
Office Excel 2007 spots formulas that can be calculated concurrently, and
then runs those formulas on multiple processors simultaneously (this capability is called
“multithreaded calculation”). The net effect is that a given spreadsheet finishes
calculating in less time, improving overall calculation performance.
Support for Tables
Office Excel 2007 helps you quickly construct, format, and expand tables using the
Ribbon and the table gallery.
Enhanced Table Tools
It is now easier to create tables. Enhancements in Office Excel 2007 help you assemble
data into a table with just a few clicks. When you need to expand the table to
accommodate more data, Office Excel 2007 quickly expands the table using the proper
format.