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

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

by MF

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).

File

Seems not a drastic change.

Edit 

Edit goes Home.

View

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

Basically, View is View.

Insert

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

Format

Format goes Home.

Tools

So many changes to Tools… @_@

Data

Well, Data is still Data.  Except PivotTable.

Windows

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.

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1