Over the years, perhaps the most common complaint about Excel was the size of a worksheet. Users who required more rows or columns were simply out of luck. Microsoft finally, responded, and Excel 2007 has upped the ante significantly. A worksheet now has 1,048,576 rows and 16,384 columns, which works out to more than 17 billion cells—almost three cells for every man, woman, and child on the planet. Stated differently, an Excel 2007 worksheet has more than 1,000 times as many cells as an Excel 2003 worksheet.

In addition to a larger worksheet grid, Excel 2007 has also increased some other limits that have frustrated users. Table 12-1 summarizes some of these changes.

TABLE 12-1
By the Numbers: Excel 2003 versus Excel 2007

Number of rows 65,536  vs 1,048,576
Number of columns 256 vs 16,384
Amount of memory used 1GB vs Maximum allowed by Windows
Number of colors 56 vs 4.3 billion
Number of conditional formats per cell 3 vs Unlimited
Number of levels of sorting 3 vs 64
Number of levels of undo 16 vs 100
Number of items shown in the Auto-Filter dropdown 1,000 vs 10,000
The total number of characters that can display in a cell 1,000 vs 32,000
Number of unique styles in a workbook 4,000 vs 64,000
Maximum number of characters in a formula 1,000 vs 8,000
Number of levels of nesting in a formula 7 vs 64
Maximum number of function arguments 30 vs 255

• Weight Tracking (Last Attempt) Total Weight Lost: 58lbs Here is my weight tracking page... It will evolve as I get more accustomed to my...
• Who is Going to Take Care of your Pet IF you Die? Was reading a trade publication today called Trusts and Estates Magazine, I LOVE this magazine - it is a wealth...
• “How To” Start Trading The Forex Market ? How Currencies are quoted and what moves individual currencies? ONE of the individual advantages in FOREX Trading is The become...
• CD Rate Roundup - Best Bank CD Rates in May Emergency savings accounts are all the rage these days, and while many people keep theirs in a high yield saving...
• Are Certificate of Deposits (CDs) worth it? I can't be the only one out there, but I can't grasp why people would do invest/purchase a Certificate of...