Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
We place all of the “Shortcut of the Week” tips from 2005 in the one convenient place.
Tip 1 – 12th of January
The Outlook navigation shortcuts could be more intuitive but here they
- Switch to Mail CTRL+1
- Switch to Calendar CTRL+2
- Switch to Contacts CTRL+3
- Switch to Tasks CTRL+4
- Switch to Notes CTRL+5
Which relate to the folder pane on the left-side of the screen.
Would that the shortcuts were more like this one to jump to the inbox:
- Switch to Inbox CTRL+SHIFT+I
Tip 2 – 20th of January
We’re always changing the format of Excel cells – fixing the date format, wrapping text in cells, whatever. So here’s how to jump straight to the cell formatting dialog.
Cell Format Ctrl + 1
That’s the Control key plus the number one – from the row above the letters on your keyboard.
Tip 3 – 28th of January
How can you quickly jump to an Outlook message from a long list.
- Sort the emails by senders name, click on the column headings to do that
- Click on a message in the list to make sure the cursor focus is on the list
- Then press the letter you want and the list should jump to the first entry with that letter. Press T and the list will go to the first T entry.
It gets better – quickly type the first letters and it’ll move further down. Press T E quickly and you’ll jump to the first entry that starts with ‘te’, this will work for many characters as you type in succession.
If you pause too long between letters Outlook will think you’ve started another search and, from the example above, you’ll jump to the first T entry then the first E entry.
This tricks works however the Outlook list is sorted – it’ll also work when sorted by Subject. It also works in Outlook Express.
Tip 4 – 3rd of February
The Split view in Frontpage 2003 is our preferred way to design a page. You can see the HTML code and page views at the same time. Often you switch between the two views and there’s a way to do that without a mouse movement.
- Alt + Page Down
- Alt + Page Up
Both act as toggles to switch between the upper and lower panes.$$PAGE$$
Tip 5 – 9th of February
Sometimes audiences get fixated on the Powerpoint screen – their glazed stare is like the proverbial bunny in the headlights. You can break the spell by turning off the display while leaving the presentation running.
Simple keystrokes will switch the display to black or white (the latter also good to display your menagerie of shadow animals).
B or period/fullstop will toggle the display between BLACK and normal
W or comma will toggle the display between WHITE and normal
The letter can be upper or lower case.
Tip 6 – 16th of February
There are many ways to jump between different Outlook folders. One option is:
Ctrl + Y open folder dialog
This shortcut will open a list of Outlook folders, click on the folder you want and the window will change to that folder. Sadly this feature doesn’t let you open a separate window, just change the current window.
Tip 7 – 28th of February
Moving around Access forms can be easier if you remember some shortcuts.
I often have to change the same field in multiple records, you can jump between records in a form while keeping the cursor in the same field using the Ctrl + Page options.
Move to next record Ctrl+PageDown
Move to previous record Ctrl + PageUp
Tip 8 – 17th of March
Jump straight to the File | Open dialog box by simply pressing:
Ctrl + F12
- Quick Access toolbar – keyboard shortcuts
- More Office 2007 keyboard shortcut tips
- Office 2007 – new look – same shortcuts
- Function Key Display – Office 2003
- Shortcut of the Week – 2004 compendium
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.