Archive | July, 2015

Tame your computer – active attachment

26 Jul

When you want to attach a copy of a document to an email message, do you do that from Outlook? Did you know you can do it immediately from, say, Word? Perhaps you use the Save & Send option from the File menu, but that’s four clicks and it can be faster! Especially if you add the E-mail button to your Quick Access Toolbar.

Here’s how:

  1. Create or open the document, as normal.
  2. Click on the arrow on the right side of the Quick Access Toolbar and click on E-mail. (You only have to do this once, to add the button to the toolbar.)
  3. Click on the E-mail button on the Quick Access Toolbar.

Microsoft Outlook will open automatically with the active document attached to the new email message. If it’s a completely new document that you didn’t save as yet, it will be attached to the email message as Document1, Book1, Presentation1 etcetera. If you want to attach additional files, you can add them as normal by clicking on the paperclip in Outlook

Tame your computer – delete the empties

18 Jul

Excel is a popular program that can save you countless hours in calculating and recalculating information. You can also use its powerful filters and PivotTables to quickly retrieve information and manipulate it in numerous ways. Blank rows, however, makes this all difficult and messy. OK, you can obviously delete your empty rows one by one, but there’s a quick way to select and delete all of them.

Here’s how:

  1. If necessary, select the range containing the empty rows.
  2. Press F5 and click on the Special button.
  3. Click on the Blanks radio button and click OK.
  4. All rows containing a blank cell anywhere in the row are selected, so be careful to check the data!
  5. On the Home tab, in the Cells group, click on the arrow next to the Delete button and select Delete Sheet Rows.

And wouldn’t these steps be a great one to record as a macro? See Tip 351 for further details.

Tame your computer – project yourself!

7 Jul

Many many moons ago (before Windows 7) it was rather tedious to connect your laptop to a projector and show a presentation on a large screen. Every laptop seemed to have a different keyboard shortcut combination, which obviously added to the stress of giving your talk.

Windows 7 provides a quick and easy way to show a presentation on a projector.

Here’s how:

  1. Plug the projector cable into the relevant port of your laptop.
  2. Press WIN + P.
  3. Select Duplicate (assuming you want to see your what’s on your laptop on both your computer screen and the projector).

By the way, speaking of presentations … did you know that the Number One Fear among adults is public speaking? Number two is death. That’s right – death is number two.

So for a lot of us the fear of standing in front of a crowd comes above the fear of death. Comedian Jerry Seinfeld says that this must mean that at a funeral most people would rather be the one in the casket, than the one giving the eulogy. Just realise that there are various tricks that you can use to help reduce your anxiety. Although you’ll probably never fully rid yourself of all the “butterflies” in your stomach, you can get them to fly in formation.