Comparison Between Ms Excel 2003 Vs Ms Excel 2007

Excel 2003 Vs  2007 Comparison

Features Excel 2003 Excel 2007
Number of Rows 65,536 1,048,576
Number of Columns 256 16,384
Number of Colors 56 4.3 Billion
Number of Conditional formats per Cell 3 Unlimited
Number of Level Sorting 3 64
Number of Level Undo 16 100
Number of Item shown in Auto filter Drop down 1,000 10,000
Total Number of characters that can display in a cell 1,000 10,000
Maximum no of characters in a Formula 1,000 8,000
Number of Unique styles in a workbook 4,000 64,000
Number of levels of Nesting in formula’s 7 64
Number of If’s Conditions 7 64
Maximum Number of Function Arguments 30 255
Amount of Memory Used 1 G bytes Maximum allowed by Windows
File Extensions .Xls .xlsx /.xlsm /.xlsb

Excel Version History

Excel Version History
Version Released Comments
1 1985 Version 1, for the Macintosh was released.
2 1987 The first Windows version was labeled “2” to correspond to the Mac version. This included a run-time version of Windows.
3 1990 Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.
4 1992 The first “popular” version. Included lots of usability features.
5 1993 A major upgrade. Included multi-sheet workbooks and support for VBA.
7* 1995 Known as Excel 95. The first major 32-bit version of Excel**. Feature-wise, it’s very similar to Excel 5.
8 1997 Known as Excel 97. A new interface for VBA developers, User Forms, data validation, and lots more.
9 1999 Known as Excel 2000. Can use HTML as a native file format, “self-repair” capability, enhanced clipboard, pivot charts, mode less user forms.
10 2001 Known as Excel 2002, this is part of Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes.
This version features product activation technology (i.e., copy protection). Please consider the ramifications of this before deciding whether to upgrade.
11 2003 It’s called Microsoft Office Excel 2003.
The new features in this version are: (a) improved support for XML, (b) a new “list range” feature, (c) Smart Tag enhancements, and (d) corrected statistical functions. Most users will not find the upgrade worthwhile.
12 2007 Finally, some major changes in Excel. For some, the changes may actually be too major.
14 *** 2010 New features include spark line graphics, pivot table slicers, an updated Solver, and a 64-bit version..
15 2013 New features include a single-document interface, charting enhancements, and recommended charts and pivot tables.
* There is no Excel 6. Beginning with Excel 7, the version numbering was changed so all of the Microsoft Office applications would have the same version number.
** There was also 32-bit version of Excel 5, but it was not widely distributed.
*** There is no Version 13 of Microsoft Office