Archive | October, 2015

Tame your computer – mouse magic

31 Oct

When editing or formatting a table in Word, you often have to select a cell, column, row or perhaps even the whole table prior to performing a particular operation. Do you use the Select button on the Table Tools, Layout tab? Or are you a right-mouse clicker and use the options under Select? But did you know you can use a single-click, as long as your mouse is properly positioned?

Here’s how:

Select a single cell: point to the left edge of the cell and click the mouse button as soon as the mouse pointer appears as a small black arrow pointing diagonally upward and to the right.

Select a row: point to the immediate left of the row of the table and click as soon as the mouse pointer appears as a large white arrow pointing diagonally upward and to the right.

Select a column: point to the top border of the column of the table and click as soon as the mouse pointer appears as a small black arrow pointing downward.

Select the entire table: point anywhere in the table and click on the icon with four arrows that appears in the upper left corner of the table.

To select multiple rows or columns, simply select a row or column as described above, hold down the mouse button and drag the mouse up, down, right or left.

If this strikes a chord, you might want to check out Tip 50 for tricks and shortcuts for selecting blocks of text using your mouse, or Tip 51 if you prefer to use your keyboard.

Tame your computer – data additions

24 Oct

After you create a chart in Excel (F11, anyone?) you might need to add new, additional data to the existing graph. As always, there are various ways to do this. I personally feel Microsoft has over-complicated the Select Data option in the Data group on the Design tab. If the chart is stored on the same sheet as the data, you can simply drag the “sizing handles” to add the new data.

But if the chart is on a separate chart sheet or you don’t understand what I mean with or cannot see the sizing handles, you can copy the additional worksheet data into the chart.

Here’s how:

  1. On the worksheet, select the cells that contain the data that you want to add to the chart.
  2. Copy, as normal. (CTRL + C)?
  3. Select the chart or go to the chart sheet into which you want to paste the copied data.
  4. Press ENTER or CTRL + V.

By the way, have you ever noticed that as soon as you copy something, Excel is telling you what to do on the Status Bar in the bottom left corner of the screen? Select destination and press ENTER or choose Paste.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.

Tame your computer – get back!

18 Oct

All web browsers keep a record of every page you visit and there are various ways to access it. You no doubt know you can use the browser’s Back button to return to the last page you visited. Or perhaps you hold down the SHIFT key and roll the wheel down, as described in tip 136?

Maybe you right-click the Back button or press CTRL + H? Well, during a training session earlier this week one of my course participants told me a method I was unaware of.

Here’s how:

1.       Click and pull down the Back button.

I cannot remember who it was who shared this tip, but I’m very grateful. Thanks!

Tame your computer – folder finesse

10 Oct

Is your Outlook inbox an overstuffed, out-of-control beast or are you a neat and tidy person and you store your email messages in separate mail folders? If you are the organised type and work with email folders, you probably end up rummaging through your Sent Items folder searching for email messages that you would really like to find in a specific folder you created about the topic.

Did you know that when replying to a message that is not in the Inbox, you can automatically save the reply in the same folder?

Here’s how:

  1. On the File tab, click on Options.
  2. Click on Mail (or type the letter m).
  3. In the Outlook Options dialog box, under Save messages (half way down the list) tick the When replying to a message that is not in the Inbox, save the reply in the same folder check box. (Or – after step 2 – press TAB, type the letter m and press the SPACEBAR to tick the check box.)
  4. Click on the OK button or press ENTER.

Next time you reply to a message, your reply will be saved in the same folder, unless the message was still in your inbox, in which case it will be stored in the Sent Items folder, as it used to be.