Office 2007 “ribbon” v Office 2003 menus

Moving from Excel and Word 2003 to the 2007 versions I found it very slow to do anything in the new versions. Below are some helps I found. (For details of problems transitioning Excel 2007 see my post on 10 May 2011)

1) Finding the icon in 2007 – interactive guide
You can use this guide from the web link or download it to yuour PC. It’s really helpfu: click a menu item in Excel 2003 and it shows you where the equivalent is in Excel 2007:

2) 2003 Keyboard shortcuts
In Word 2003, I used to use the keyboard shortcuts finding them quicker than icons. The 2003 keyboard shortcuts actually still work in Office 2007 (eg Alt O P to format a paragraph)

3) Office 2007 shortcuts
Office 2007 has its own keyboard shortcuts: press Alt and the ribbon-based ones are displayed.
Here’s a good list of keyboard shortcuts (eg CTRL Asterisk to select the current region)

Also worth knowing … CTRL Shift ! for number format with 2 decimals; or CTRL Shift ( to unhide hidden rows

3) Install the Excel 2003 menus into Excel 2007
free download:
Or you can pay for something similar:

and if you really don’t like that ribbon …
try CTRL F1

0 Responses to “Office 2007 “ribbon” v Office 2003 menus”

  1. Leave a Comment

Leave a Reply

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

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s




%d bloggers like this: