First thing to do when switching from Excel 2003 to 2007/2010

is to know where are the old menus and toolbar icons!!!

I guess there are still a lot of of Excel 2003 users in Hong Kong, mainly in workplaces.  No idea if it is also common in other cities. There are so many reasons for not upgrading.  Not to my surprise, one of the most commonly heard reasons is the resistance to change.

As an ordinary user, I am sure you would feel more frustration than excitement on the first day you switched from Excel 2003 to 2007/2010/2013.  Before you could appreciate the benefits from (just to name a few)

  • the enhanced features in Conditional Formatting
  • the variety and functionality of new Functions
  • the introduction of Table in 2007
  • the introduction of Slicer in 2010
  • the improvement in Auto Filter
  • so on and so forth

you probably faced difficulties in basic stuff like Printing and Page Setup… 😦  Does it sound familiar?

If you just switched from Excel 2003, or are planning to do so, the first thing you should do is to spend time to get yourself familiarized with the new Interface – the Ribbon.

Let’s see where are those “File”, “Edit”, “Insert”, “Format” etc in the new Excel. (note: Excel 2002 and 2010 being used in the following screenshots).




Seems not a drastic change.



Edit goes Home.



  • For “Header and Footer…”, go to Page Layout tab
  • For “Comments”, go to Review tab

Basically, View is View.



A lot of migration happened to “Insert”  ~_~




Format goes Home.




So many changes to Tools… @_@




Well, Data is still Data.  Except PivotTable.




Windows goes View.


Chart Tools and PivotTable Tools




Note: Pay attention to the Ribbon.   Corresponding tools are available when an object is selected.


What about Right Click Menu??


We don’t need it at all as most of them have been grouped into different tabs of the Ribbon.

No?! There are something icons not being found on any tabs on the Ribbon.


You are correct.  Maybe that’s what Quick Access Toolbars (QAT) for!



Btw, more customization can be made to Ribbon in Excel 2010.


So far, I hope I have outlined the major changes in layout between the old and new Excel.  If you are eager to learn more, I would highly recommend you the following:

This free ebook from Bill Jelen (also known as Mr Excel) is simply awesome!!! 🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Basic and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.