Archive | October, 2013

Tame your computer – change your shape

20 Oct

Microsoft Office’s built-in Picture Styles on the Picture Tools ribbon provides a quick way to add fancy borders to your pictures. But what if you want to have more control over the corners or shape of your picture?  For example, during a recent PowerPoint course, Lee, Theresa and Nicky wanted to round the corners in a specific way that matched the branding of their organisation.  (Thanks for the inspiration, guys!)

Here’s how:

  1. Double-click the picture you want to change, which will display the Picture Tools ribbon.
  2. In Office 2007: On the Format tab, click on the Picture Shape button and select the shape you want.  In Office 2010: On the Format tab, click on the Crop’s drop-down arrow, select Crop to Shape and select the shape you want.
  3. If the new shape has a small, yellow diamond-shaped handle, you can drag it to adjust the shape.

Tame your computer – keep a look out in Outlook

9 Oct

Last year (13 September 2012, to be precise) I wrote a tip about how to use Outlook’s Instant Search box to reduce irrelevant search results. This week I got an email from a friend telling me her email hadn’t been working for a while and that messages sent to her might have sunk into the virtual swamp. So, inspired by her (thanks, Sally!) this week’s tip is about how to search for messages sent to a particular person during a specific period.

Here’s how:

  1. Open Outlook 2010’s Sent Items folder.
  2. Press CTRL+E to jump to the Instant Search box and activate the Search Tools ribbon.
  3. Click on the To button and type (part of) the recipient’s email address. (As you will notice – if you look at your screen, rather than your keyboard – search results will be displayed as you type.)
  4. Click on the drop-down arrow next to the This Week button and filter your search results based on when the message was sent (e.g. last month).

If you cannot find what you are looking for, click on the All Mail Items button on the Search Tools ribbon, so that it won’t just look in the Sent Items folder, but also in all the subfolders.

Tame your computer – give it a squeeze

4 Oct

Last week I told you how to squeeze a few last rows or columns onto a single page in Excel. There is a similar functionality available in Word, but since version 2010 this option is hidden away. (If you are still using version 2007, you can find the Shrink One Page button on the Print Preview ribbon.)

So why not stick the Shrink One Page command onto your Quick Access Toolbar?

Here’s how:

  1. Click on the arrow on the right side of the Quick Access Toolbar.
  2. Click on More Commands.
  3. In the Choose commands from drop-down list, select All Commands.
  4. Scroll down and double-click on Shrink One Page.
  5. Click OK.

Next time you want to squeeze those last lines onto a single page, simply click the Shrink to Fit button on your Quick Access Toolbar and Word will attempt to shrink the document to one page by slightly reducing the size and spacing of the text.

By the way, the new button will be added at the far end of the toolbar, which might not be the spot where you want it, so if you want you can move it to your desired location on the Quick Access Toolbar; see this tip if you need a hand.