Tame your computer – top 10 tips for Microsoft PowerPoint

22 Apr

Following the success of the recent top ten Excel, Word and Outlook tips, herewith your favourite PowerPoint shortcuts with links to the relevant tips, if any.

Enjoy!

1 F5 Start slide show from first slide
2 SHIFT + F5 Start slide show from current slide
3 ALT + SHIFT + down arrow Move text or bullet points down
4 ALT + SHIFT + up arrow Move text or bullet points up
5 SHIFT + F9 Show or hide grid for positioning objects
6 ALT + F9 Display drawing guides on screen
7 CTRL + SHIFT + G Group/ungroup shapes, pictures, or SmartArt
8 CTRL + left mouse button Laser pointer in Slide Show View
9 CTRL + D Duplicate selected slide
10 SHIFT + F3 Toggle between UPPER CASE, lower case and Sentence Case

 

Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I drip feed a new shortcut weekly, to help you to boost productivity without reaching for your mouse.

Tame your computer – jump to it

14 Apr

Do you use Google Calendar? Perhaps not for work, but privately? It’s a free, intuitive online calendar developed by Google that you can easily access from your phone, tablet or computer. If you want, you can even share it with family or friends.

Like with Outlook, there are various ways to display a specific date in Google Calendar. If you want to jump to a specific date there is a great shortcut.

Here’s how:

  1. Open Google Calendar on your computer.
  2. Press G. (Easy to remember if you think of Go To.)
  3. Type the date you want to jump to. For example, 1/5. (No need to type the leading zeros or year.)
  4. Press ENTER or click GO.

To redisplay today’s date click on the TODAY button or simply press G and type today.

Oh, and how about the following three shortcuts:

  1. D: show the daily view
  2. W: show the entire week
  3. M: show the month

Related tip: Jump to a specific date in your Outlook calendar

Tame your computer – top 10 tips for Microsoft Outlook

1 Apr

For those of you who have been paying attention to my tips this month you probably saw this coming … herewith your favourite Outlook shortcuts with links to the relevant tips, if any. I hope you enjoy them as much as you did the recent top ten Excel and Word tips!

1 CTRL + 1 and CTRL + 2 Toggle between Mail and Calendar
2 CTRL + F Forward a mail message
3 CTRL + G Go to a specific date
4 CTRL + K Check names in address fields and resolve them against the Address Book
5 CTRL + K Insert Hyperlink
6 CTRL + SHIFT + 8 Show/Hide paragraph marks and other hidden formatting symbols
7 F3 AutoComplete Quick Parts
8 F4 Find text in an email message
9 SHIFT + F1 Reveal Formatting
10 SHIFT + F3 Toggle between UPPER CASE, lower case and Sentence Case

Tame your computer – find the filter

19 Mar

If you can’t find the data you’re looking for in a worksheet, it might be hidden by a filter.  When you apply a filter, entire rows are hidden if values in one or more columns don’t meet the filtering criteria. There are three quick ways to see whether a filter has been applied to the sheet.

Here’s how:

  1. If the button next to one of the column headings displays a funnel it means a filter has been applied.  OR
  2. In the bottom left corner of the workbook, on the Status Bar, the number of records found is displayed or it might simply say “Filter Mode”. OR (my favourite)
  3. The Clear button on the Data tab has a red cross next to it.

To get rid of all of the filters in a worksheet at once click the Clear button on the Data tab. Or better still, right-clickthe Clear button and select Add to Quick Access Toolbar.

In future, if you want to know whether or not a table has been filtered you check whether the Clear button on the Quick Access Toolbar has a red cross and if so, you simply click it to clear all filters.

By the way, if you still cannot find the data, you might have hidden rows or columns. See tip 478 for help on how to find these.

With thanks to Ian for this week’s tip inspiration!

Related tips:
Filter dates by month

Find hidden rows and columns in your worksheet
Filter data in a PivotTable and PivotChart using Slicers
Quickly format and enable filtering of your data
Fast filtering

Tame your computer – top 10 tips for Microsoft Word

13 Mar

Following the success of my recent top ten Excel tips (even Microsoft themselves @msexcel tweeted “Great tips!” – woohoo!) here are your favourite Word shortcuts with links to the relevant tips, if any. I hope you enjoy them!

1 CTRL + ALT + 1 Apply Heading 1 style
  CTRL + ALT + 2 Apply Heading 2 style
  CTRL + ALT + 3 Apply Heading 3 style
2 CTRL + ENTER Insert page break
3 CTRL + F Open the Navigation Pane
4 CTRL + G Display the Go To dialogue box
5 F3 AutoComplete Quick Parts
6 F4 Repeat your last action
7 F7 Select the Spelling command
8 SHIFT + F1 Reveal Formatting
9 SHIFT + F3
Toggle between UPPER CASE, lower case and Sentence Case
10 SHIFT + F5 Return to the location you were last working in

CTRL + G also works in Excel and Outlook; F3 and SHIFT + F1 also in Outlook; F4 also in Excel and PowerPoint and SHIFT + F3 also in Outlook and PowerPoint.

Oh, and if you want to add any of the tip pages to your list of Favorites/Bookmarks, simply press CTRL + D.

See http://www.roem.co.uk/inc/shortcut_archive.pdf for a list of all the shortcuts published since March 2013 when we launched the ‘shortcut of the week’ on our home page.  Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I drip feed a new shortcut weekly, to help you to boost productivity without reaching for your mouse.

Tame your computer – top 10 tips for Excel

24 Feb

What I often hear from my course participants is that they came away with new tricks, tips and shortcuts that they never would have found on their own.

Here are your favourite, most commented on Excel shortcuts, with links to the relevant tips. I hope you enjoy them!

1 ALT + ENTER Insert line breaks
2 ALT + 7 Create a bulleted list
3 CTRL + ; Insert today’s date
4 CTRL + A twice Select the entire table, including the table headers
5 CTRL + down arrow Move to end of a range of cells in a column
6 CTRL + G Display the Go To dialog box
7 CTRL + T Format as table, enabling filtering
8 F11 Create a chart in a separate sheet
9 F2 Switch to Edit mode
10 F4 Repeat your last action

By the way, CTRL + G also works in Word and Outlook and F4 in Word and PowerPoint.

Finally, see http://www.roem.co.uk/inc/shortcut_archive.pdf for a list of all the shortcuts published since March 2013 when we launched the ‘shortcut of the week’ on our home page.

Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I drip feed a new shortcut weekly, to help you to boost productivity without reaching for your mouse.