Subscribe!

I try to make all of the advice I offer on this blog generic to all Excel versions. Sometimes it is useful to know some of the more important (or useful) differences. Below are some of the differences that I try to keep a mental note of:

2000
Digitally signed macros
Pivot Charts
User forms
VBA 6 introduced

2002
Colored worksheet tabs
Formula format displayed as you enter functions
Improved worksheet protection
Insert graphics in headers and footers

2003
Compare worksheets side by side option
List first introduced
Improved XML functionality

2007
Apply fill effects to cells
Edit headers and footers from page layout view
Improved auto-shapes
Improved chart formatting and display options
Improved conditional formatting
Increased number of rows and columns
Ribbon rather than toolbar/menu combination
List became tables

Joseph Harris
Excel Help

Related posts:

  1. Excel Data Validation Data validation gives the Excel developer a way of dictating...
  2. Duplicates – Finding and Removing in Excel There are many occasions when you may need to remove...
  3. Print Area and Print Preview – Analyst Best Practices Even Though we are progressing towards a paperless society, the...
  4. Data Validation List on Seperate Sheet How to create list for data validation on different sheets...
  5. Automatic Updating “Dynamic” Charts in Excel One of the most time consuming parts of producing a...

This entry was posted on Sunday, October 26th, 2008 at 8:01 am and is filed under Excel Hints. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Excel Version Differences”

  1. Jon Peltier on October 28th, 2008 at 5:23 am

    User forms were introduced in Excel 97.

    Excel 2003 introduced Lists (which became Tables in 2007), which was all the prodding I needed to upgrade to 2003. 2003 also had improved XML functionality.

  2. Joseph Harris on October 28th, 2008 at 5:56 am

    Thanks John…I added these changes to the list.

Leave a Reply

You must be logged in to post a comment.