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:

http://office.microsoft.com/en-us/training/guides-to-the-ribbon-use-office-2003-menus-to-learn-the-office-2007-user-interface-HA010229584.aspx?CTT=3

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)
http://www.leedr-project.com/it/access/excel2007-shortcuts.html#ctrl

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:
http://download.cnet.com/Classic-Menu-for-Excel-2007/3000-2077_4-10637173.html
Or you can pay for something similar:
http://www.mrexcel.com/classicexcelmenu.html

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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




Categories

Archives


%d bloggers like this: