Archive | Microsoft Office RSS feed for this section

Tame your computer – revise, reuse, rename

6 Sep

If you’re going to create a new file, based on an existing one, but only want your changes saved in the new document you can obviously use the Save As command (or press F12). But did you know it’s also a great way to reuse an existing filename with a similar title?

Here’s how:

  1. Open your document.
  2. Press F12.
  3. Do one of the following:
  • Type the new filename (no need to press the Delete key first) OR
  • Press End to move to and amend the end of the filename OR
  • Press Home to move to and amend the beginning of the filename

Your original document will remain unchanged and all your edits will be in the new copy.

Related tips
Time-saving shortcut key to use Save As command 
Quickly rename or copy a file or folder name 
Quickly add to the end of cell contents

Tame your computer – make a quick exit

25 Aug

If, like me, you prefer to use your keyboard rather than your mouse you might know – or want to know – that Microsoft introduced “KeyTips” in Office 2007, offering a quick way to select commands using your keyboard. One of the favourite KeyTips of my dear friend Danijela is ALT, F, X which will select the Exit command from the File tab.

Here’s how:

  1. Press ALTFX. (Or Press ALT + F4.)
  2. When prompted, type the underlined letter s (Save) or n (Don’t Save) or press the ESC key to cancel the operation.

This will close down the whole application, not just the active document, as described in tip 272.

I’ll update the shortcut archive but in the meantime a big thank you to Dani for this week’s tip inspiration!

 

Related tips:
Selecting commands without using your mouse
Close a window without clicking in the upper-right corner 

Tame your computer – picture perfect

20 Aug

I’m sure you’ll agree that it can sometimes be a time-consuming and frustrating exercise to get pictures the size and shape you want. But did you know that once you got one the way you like it to be, you can easily replace it with another picture? As far as I can tell you can do this in Word, Excel, PowerPoint and Outlook, but I think it’s most beneficial in your Word and PowerPoint templates.

Here’s how:

  1. Right-click the picture you want to replace and select Change Picture.
  2. Find the new picture and double-click it.

If you prefer, you can also use the Change Picture button in the Adjust group on the Picture Tools Format tab.

With special thanks to Alison for this week’s tip inspiration!

Related tips
How to change the shape of a picture 
Tweak your SmartArt graphics
Pimp your chart 
Add a cover page
Make the background of a picture transparent 

Tame your computer – Best of 2017: top 10 tips

17 Dec

Hello for the last time in 2017.

Here are your favourite, most commented on, tips from the past 12 months to get you inspired for the year ahead. I hope you enjoy them!

  1. Schedule your e-mail message to be sent at your preferred date and time (Microsoft Outlook)
  2. Fast way to start a bulleted or numbered list (Microsoft Word and Outlook)
  3. Reopen recently closed tabs (Chrome, Internet Explorer and Firefox)
  4. Find the best time to schedule a meeting (Microsoft Outlook)
  5. Show changes and comments inline instead of in balloons (Microsoft Word)
  6. Change the colour of public holidays in your calendar (Microsoft Outlook)
  7. Protecting your formulas (Microsoft Excel)
  8. Quick way to paste content of the clipboard into an email message (Microsoft Outlook)
  9. Create a bulleted list in your workbook (Microsoft Excel)
  10. Find email messages sent or received between certain dates (Microsoft Outlook)

Oh, and don’t forget to check out this handy tip before you go off on your holidays; it contains five ways to prevent email overload upon your return from a break.

Wishing you a relaxing holiday season. Remember: Escape isn’t just a button on your keyboard!

Tame your computer – get back!

19 Sep

The go-back-to-where-I-was-happy (aka Undo) button seems to be well-known among most people. It allows you to reverse one or more operations and restore a document or an e-mail message to its previous state.  It is useful when you find that you have accidentally deleted some text or have performed some other operation that has unintentionally modified your document.

But even though the Undo button seems to be the first tool anyone remembers, a lot of people seem unaware you can simultaneously undo or redo a series of operations in Word, Excel, PowerPoint and Access. (Why not in Outlook beats me!)

Here’s how:

  1. Click on the down arrow at the right side of the Undo button. (The button is located on the Quick Access Toolbar.)
  2. Select the desired actions from the list that you want to reverse.

You can also redo actions that have been undone. Redo is also great for repeating an action. By the way, only in Excel, you can redo several undone actions in one go, similar to the undo action described in this tip.

Oh, and for the keyboard shortcut lovers among us:

  • Press and hold the CTRL key and press the Z key to undo an action.
  • Press and hold the CTRL key and press the Y key to redo (or repeat) an action.

Finally, some trivia … Apparently, you can do unlimited undos in Word and (individual ones) in Outlook, as well as up to 100 in Excel. By default, you can “only” undo up to 20 actions in PowerPoint, but you can increase that by following the steps as described in this tip.

Tame your computer – the top 10 tips of 2016

19 Dec

This will be the last tip of the year as I’m pretty sure that you’re all ready to tuck into mince pies and mulled wine.

So here are your favourite, most commented on, tips from the last 12 months. Don’t forget to check out number 6 before you’re off on your Christmas break!

  1. Add holidays to your calendar (Microsoft Outlook) – http://roem.co.uk/tip_471.php
  2. 10 tips for safe online banking – http://roem.co.uk/tip_473.php
  3. Make text look like it was marked with a highlighter pen (Word and Outlook) – http://roem.co.uk/tip_475.php
  4. Stop AutoCorrect from capitalizing text following specific abbreviations (Microsoft Office) – http://roem.co.uk/tip_476.php
  5. Create, store and insert frequently used text and graphics (Microsoft Word and Outlook) – http://roem.co.uk/tip_486.php
  6. Five tips to prevent email overload upon your return from holiday (Microsoft Outlook) – http://roem.co.uk/tip_489.php
  7. How to remove limitations of what is displayed in a cell (Microsoft Excel) – http://roem.co.uk/tip_491.php
  8. Set the default colour of a hyperlink (Microsoft Outlook) – http://roem.co.uk/tip_492.php
  9. Automatically move low-priority emails from your inbox (Microsoft Outlook) – http://roem.co.uk/tip_496.php
  10. Change the emphasis of a SmartArt graphic by changing its direction (Microsoft Office) – http://roem.co.uk/tip_501.php

Wishing you a relaxing holiday season. Escape isn’t just a button on your keyboard!

Tame your computer – get smart with SmartArt

11 Dec

Don’t you love SmartArt?! They are quick and easy to create and you can choose from many different layouts, making it easy to communicate your message or ideas effectively in Excel, Word, and Outlook, but mainly – I guess – PowerPoint.

But what if you need to change the emphasis or reverse the flow of your SmartArt graphic? Well, you can switch the layout of the SmartArt graphic between left to right and right to left with one simple click.

Here’s how:

  1. Click anywhere in the SmartArt graphic that you want to change.
  2. On the SmartArt Tools Design tab, in the Create Graphic group, click Right to Left. (If you don’t see the SmartArt Tools Design tab, you didn’t click on a SmartArt graphic.)
  3. To switch back to the original direction of your SmartArt graphic, click Right to Left again.

What happens depends on the type of SmartArt, but, say, you used a basic chevron process (“arrows pointing to the right” for you and me) … one click on Right to Left and hey presto, the arrows are pointing the other way.

By the way, the feature isn’t available for all SmartArt graphics and the customisation might get lost when you select a different layout, but I still really like the feature.

For more tips about working with SmartArt graphics see:

Tip # 355: Tweak your SmartArt graphics (Microsoft Office)

Tip # 268: Convert an existing bulleted list to a SmartArt graphic (PowerPoint)

Tip # 230: Draw three concentric circles with text in each (Microsoft Office)

Want to learn more? For a  schedule of my upcoming courses, click here. Affordable. Guaranteed to run. And fun!