Chapter 7. The Big Grid

In this chapter

Excel 2007 Grid Limits 122

Other Limits in Excel 2007 125

Working with Excel 2003 Named Ranges in Excel 2007 127

Tips for Navigating the Big Grid 127

The biggest fundamental change in Excel 2007 is the increased grid size. Microsoft is fond of calling this “the big grid.” I would say that “big” is an understatement. When I heard rumors in 2004 that Microsoft would add rows to Excel, I thought perhaps they would double the 65,536 rows and Excel would have 130K rows. I even mentioned to Excel project manager Dave Gainer that if they didn’t increase to at least 130K rows, it would be disappointing. For columns, I thought Microsoft would increase it to 1,024 columns, enough for three years of workday dates. ...

Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.