Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Monday, January 05, 2009 – Permalink –

Excel 2007 Limits

New Boundaries

Here are a few of the major changes in Excel 2007.
The total number of available columns in Excel

Old Limit: 256 (2^8)
New Limit: 16k (2^14)
The total number of available rows in Excel

Old Limit: 64k (2^16)
New Limit: 1M (2^20)
Number of unique colors allowed a single workbook

Old Limit: 56 (indexed color)
New Limit: 4.3 billion (32-bit color)
Number of conditional format conditions on a cell

Old Limit: 3 conditions
New Limit: Limited by available memory
Number of levels of sorting on a range or table

Old Limit: 3
New Limit: 64
Number of items shown in the Auto-Filter dropdown

Old Limit: 1,000
New Limit: 10,000
The total number of characters that can display in a cell

Old Limit: 1k (when the text is formatted)
New Limit: 32k or as many as will fit in the cell (regardless of formatting)
The maximum length of formulas (in characters)

Old Limit: 1k characters
New Limit: 8k characters
The number of levels of nesting that Excel allows in formulas

Old Limit: 7
New Limit: 64
Maximum number of arguments to a function

Old Limit: 30
New Limit: 255
The number of characters that can be stored and displayed in a cell formatted as Text

Old Limit: 255
New Limit: 32k

These were reported by David Gainer.

Some other numbers

More information is available at David's blog:

A discussion of what's new in Excel

[Edited entry from 10/26/2005]

See all Topics


<Doug Klippert@ 3:37 AM

Comments: Post a Comment

Links to this post:

Create a Link