Archive | January, 2018

Tame your computer – manipulate messages

29 Jan

By default, Outlook only displays the number of unread items in brackets in blue next to the folder name.  But if you want, you can change it to show the total of both read and unread messages, similar to what you might have noticed happens to the Drafts and the For Follow Up folder.

Here’s how:

  1. Right-click the Outlook folder and select Properties.
  2. On the General tab select the Show total number of items radio button.
  3. Press ENTER or click OK.

The setting also applies to your Favorite folders.

The total number of all items will appear in green, rather than blue.

Related tips

Display your flagged messages in a “For Follow Up” folder

How to sort your folder list the way you want it

Tame your computer – cut to the chase

23 Jan

Earlier this month a course delegate asked me whether there was a way to move a bullet point up or down in PowerPoint. Obviously you can use cut and paste, but I remembered there was a nifty keyboard shortcut. But what was it?

So I used my own search page and typed in three words (PowerPoint bullet up) and hey presto … tip 308 came up in the preview of the shortcut archive.

Here’s how:

  1. Put your cursor anywhere in the bulleted text or paragraph you want to move.
  2. Click ALT + SHIFT + UP ARROW to move the bullet point or text up or ALT + SHIFT + DOWN ARROW to move it down.

And I just noticed it also works for pictures in Word.

Tame your computer – drag and drop with Excel

6 Jan

Happy New Year! Let’s make 2018 the year that you learn heaps and have fun doing so. Hopefully this tip is a good start and worth checking out …

As you know, there are many ways to move or copy cells in Excel. Perhaps you use CTRL + XCTRL + C and CTRL + V? Or are you a “right-mouse-clicker”? Perhaps you prefer the Cut and Copy buttons on the Home tab?  Or maybe you use AutoFill to copy values and formulas into adjacent cells?

But did you know you can also move or copy any cell into any worksheet location by using a drag and drop technique?

Here’s how:

Moving cells

  1. Select the cells that are to be moved.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination of an upward-pointing arrow and four-headed arrow.
  3. Press and hold down the mouse button.
  4. Drag the mouse pointer to the new location.
  5. Release the mouse button.

Copying cells

  1. Select the cells that are to be copied.
  2. Point to the border of the selection and wait until the mouse pointer appears as a combination of an upward-pointing arrow and four-headed arrow.
  3. Press and hold down both CTRL and the mouse button.
  4. Drag the mouse pointer to the new location.
  5. Release the mouse button and CTRL.

You can also move or copy between sheets by holding down the ALT key when dragging the content over the sheet tab.

By the way, the Paste Options button will not be displayed when you use the drag and drop method.

Related tips:
Copy the content of a worksheet