Difference Between Excel 2003 & 2007

Excel 2007 differs from Excel 2003 in a few key ways. Differences include changes to the user interface, new features and an expanded array of file formats. In addition, several limitations imposed by Excel 2003 are abolished or relaxed by Excel 2007.

Print this article

Changes to the User Interface
- In Excel 2007, Microsoft abandoned the familiar "File - Edit - View . . . " menu structure used in Excel 2003. Instead, Excel 2007 uses the "Office Ribbon"--a graphical set of buttons in which commands are logically grouped by function.
Excel 2007's New Features
- Excel 2007 contains new features, including themes, a re-sizable formula bar, enhanced sorting functions, and expanded conditional formatting capabilities. Excel 2007 provides a more robust set of spreadsheet functions than Excel 2003.
Relaxed Limitations
- Excel 2007 supports spreadsheets with more rows, more columns, more colors, more conditional formatting definitions, and more sort levels than Excel 2003.
File Formats
- Excel 2007 recognizes XLS files created by Excel 2003. It also introduces many new Office Open XML file formats (XLSX, XLSM, XLTX, XLTM and XLAM). These new formats are not backwardly compatible with Excel 2003.
Some Functionality Stayed the Same
- Although many things about the Excel user interface changed in Excel 2007, most of the underlying dialog boxes are the same in 2007 as they are in 2003 (e.g. Page Setup, Format Cells). In addition, keyboard shortcuts used in Excel 2003 also work in Excel 2007.
Help Translating Excel 2003 Commands to Excel 2007
- Help for translating Excel 2003 commands to Excel 2007 can be found at Microsoft's Excel Interactive Reference: http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033

Comments

Ervin John Dec 11, 2011
is their any further explains.
bburly Oct 02, 2011
is there any changes in data entry in ms excel?

Difference Between the Versions of MS Office 2007
Microsoft Office 2007 is the latest edition of Microsoft's productivity software. There are different versions of the office suite.
Differences Between Microsoft Excel 2003 & 2007
Microsoft Excel has graced many a PC since its introduction in the 1980s, but somewhere between Excel 2003 and Excel 2007, the...
Difference Between Microsoft Office 2003 & 2007
Microsoft's Office Suite contains Excel, Word, Outlook, PowerPoint, Access, OneNote and additional programs, depending on which suite you purchase. Office 2007 is...
Differences Between Microsoft Word 2003 & 2007
Differences Between Microsoft Word 2003 & 2007. Microsoft Word dominates the word processor market. Since 1989, its many users learned and became...
Difference Between Microsoft Access & Excel
Microsoft produces two different products---Access and Excel---that many people use interchangeably. However, each has its own purpose and one may be better...
Difference Between Microsoft 2003 & 2007
Both Microsoft Word 2003 and Word 2007 are robust word processors created by Microsoft. Once opened, the difference between the two programs...
Difference Between MS Office 2003 & MS Office 2007
The Microsoft Office Suite consists of Word (word processing), PowerPoint (presentations), Excel (spreadsheets), OneNote (digital notebook) and Outlook (email ...
How to Use Microsoft Excel Date Difference Function
If you want to find out how much time has elapsed between dates in Excel, use the DATEDIF function. The format for...
Location of Excel 2003 Commands in Excel 2007
The Excel 2007 toolbar is a radical departure from Excel 2003. The toolbar was revamped and called a ribbon, and nearly every...
Differences Between Outlook 2007 & 2003
Differences Between Outlook 2007 & 2003. Microsoft Office Outlook serves as a time and information management tool designed for business applications. The...
The Differences Between Microsoft Excel 2007 & Earlier Versions
Microsoft Excel 2007 is a spreadsheet program that is part of the Office suite of productivity software. Excel has been around for...
What is the Difference Between Excel & Microsoft Spreadsheet?
Excel and Microsoft Spreadsheet are different ways of referring to the Microsoft Excel program. Microsoft Excel consists of a series of columns...
How to Convert Excel 2007 to 2003
Microsoft released its newest form of the Office suite in 2007. These new versions of familiar programs comes with greater usability and...
Excel 2007 to 2003 Conversion
Converting involves changing one file format to another. In this case, it involves changing file formats from an newer version of Micrsoft...
Difference Between Male & Female Ladybugs
Ladybugs, also know as ladybirds and lady beetles, are small, red insects loved by farmers and feared by aphids. Despite their name,...
How to View Excel 2007 Files on Excel 2003
If you need to open a Microsoft Excel 2007 spreadsheet in Excel 2003, you may run into a problem. Excel 2007 spreadsheets...
The Difference Between Outlook 2003 and Outlook 2007
Microsoft Outlook 2007 is an updated version of Microsoft's popular personal information management software. Outlook 2007 is primarily used for email, but...
What Are the Differences Between MS Office 2007 & MS Office 2010?
Office 2007 and 2010 are Microsoft's two latest versions of its productivity suite software. These suites come with different combinations of a...
How do I Copy Color Palettes Between Excel 2007 Workbooks?
When you are working with specific data in the Microsoft Office Excel 2007 spreadsheet application, you can create workbooks that include several...
The Differences Between Microsoft Word, Excel and Access
Although Microsoft Word, Microsoft Excel and Microsoft Access share similarities, they are all suited for different objectives. Much of what one of...

Difference Between Excel 2003 & 2007

Other People Are Reading

Changes to the User Interface

Excel 2007's New Features

Relaxed Limitations

File Formats

Some Functionality Stayed the Same

Help Translating Excel 2003 Commands to Excel 2007

References

Resources

More Like This

Comments

You May Also Like

Related Ads

Kid-Approved iPad Apps by Mom.me

You May Like