Inserting hyperlinks in Excel 2010

To insert hyperlinks within an Excel workbook, follow the steps below:

  1. Display gridlines for Print view.  Select [Page Layout tab] + Sheet Options + Gridlines.  Ensure View and Print check boxes are ticked.  (This option displays the page breaks within your workbook.)
  2. Insert a row at the top of your worksheet A1.  (Blank row inserted.)
  3. Select cell in row A where you want to insert your first hyperlink.
  4. Select Insert tab click on Hyperlink(Insert Hyperlink dialog box displayed as below).
  5. Select Place in This Document.
  6. Enter name/reference in Text to display field.
  7. Enter the cell reference in Type the cell reference and select which sheet if necessary.
  8. Click OK(Your new hyperlink will now be displayed, see examples below.)

Microsoft Office Word 2007 & 2010 – Disable the Mini Toolbar

The Mini toolbar was introduced in Word 2007. It appears when you are working with text and objects in your document. Many people love the Mini toolbar, it puts commands right where you need them most – immediately beside the part of your document that you’re editing.

For other people, the Mini toolbar is distracting, and annoying. It can obstruct the very text you’re trying to format.  If you don’t like the Mini toolbar, you can disable the Mini toolbar easily by following the steps below:

  1. Click the Office button (2007) or File (2010)
  2. Select Word Options
  3. Click Popular in the left column
  4. Deselect “Show Mini Toolbar on selection”

Quick text selections

Microsoft Word tipMicrosoft Word quick word, sentence or paragraph selections

The quickest and fastest way to select a word, sentence or paragraph of text within all Microsoft versions of Word by using the mouse and keyboard keys.   No more clicking and dragging the mouse with varying results!

To select a:

–  word

double-click anywhere in a word (this also works great when you’re renaming a file)

–  sentence

Ctrl+click anywhere within a sentence

–  paragraph

triple-click anywhere within a paragraph

Outlook – making special emails stand out

Microsoft Outlook tipYou can automatically colour specific incoming emails.

By doing this you will immediately know when you have received a message from an important client or someone special. It’s easy.

Outlook 2003
  1. In the Inbox, select the email (sender) message you —- want to colour code.
  2. Click on Tools menu, click Organise.
  3. Select Using Colours.
  4. Make your selection.
Outlook 2007
  1. In the Inbox, select the email (sender) message you – want to colour code.
  2. Click on Tools menu, click Organise. (Above your -Inbox, Ways to Organise Inbox pane will appear)
  3. Click on Using Colours (email address highlighted).
  4. Select your colour.
  5. Click on Apply Colour.
  6. Close the Organise pane by clicking the X in the  upper-right corner of the pane.