Managing Larger Data Collections
Many Excel users take advantage of the program's data summary and calculation capabilities to process large data collections. In Excel 2003 and earlier versions, you were limited to 65,536 rows and 256 columns of data in a worksheet. You could always spread larger data collections across multiple worksheets, but it took a lot of effort to make everything work correctly. You don't have that problem in Excel 2007. The Microsoft Excel 2007 product team expanded worksheets to include 16,384 columns and 1,048,576 rows of data, which should be sufficient for most of the projects you want to do in Excel 2007.
Excel 2007 also comes with more powerful and flexible techniques you can use to process your worksheet data. In Excel 2003, you could assign up to three conditional formats (rules that govern how Excel displays a value) to a cell. In Excel 2007, the only limit on the number of conditional formats you can create is your computer's memory.
The table below summarizes the expanded data storage and other capabilities found in Excel 2007.