Archive | October, 2017

Tame your computer – specify your search

30 Oct

I hope you’re using the improved search that was introduced in Outlook version 2007? I don’t mean simply typing in the Search box, but using the different buttons to refine your search. For example, use the From button and click on Has Attachments and This Week to find any message from a certain person that you received this week (as long as it contains one or more attachments).

You might have noticed that the This Week drop-down list is restricting you to search for Today, Yesterday, This Week, Last Week, This Month, This Year and Last Year. So what if you want to search for a specific period?

Here’s how:

  1. Click in the Instant Search box in the top right hand corner or press CTRL + E.
  2. Type received:>=d/m AND <=d/m

For example, received:>=1/9 AND <=13/9 will find any emails that arrived between 1 and 13 September 2017.

If you did not find what you were looking for, click on the Try searching again in All Mail Items link at the bottom of the search results page.

Oh, and don’t forget that your 10 most recent searches are saved and can be found when clicking on the Recent Searches button on the Search Tools ribbon.

Related tips:
Find that needle in a haystack
Find even more needles in that haystack
Reduce irrelevant search results
Search for messages sent to a particular person during a certain period of time

 

Tame your computer – build a bullet list

23 Oct

Microsoft Excel does not have a built-in function to create a bulleted list like in Word, PowerPoint and Outlook. But during a course yesterday I found out you can create one using a nifty keyboard shortcut.

Here’s how:

  • Select the cell where the list is to appear.
  • Press ALT + 7 on the numeric keypad.
  • Type your text.
  • Press ALT + ENTER if you want to insert another bullet in the same cell.
  • Repeat steps 2 – 4.

With thanks to Alex for the tip inspiration!

Related tips:

Tip # 506: Fast way to start a bulleted or numbered list (Microsoft Word and Outlook)
Tip # 458: How to add, find and remove line breaks (Microsoft Excel)