 |
Hints and Tips |
Word
|
|
Hyperlinks
If you type a web address or email address, Word will automatically
make this a hyperlink but you can also use hyperlinks to open other documents,
either by clicking on the filename or other text such as “click
here”.
Press Ctrl + K to open the Insert Hyperlink
dialogue box.
|
 |
| Use the Link to and Look
in options to select the item you wish to add the hyperlink to.
If you click OK, Word will use the file name as the hyperlink
– if you want different text, type this in the Text to display
box. If you select text before you open the dialogue box, Word will automatically
insert it here. |
| To get rid of a hyperlink you just right-click
it and select s from the context menu. If you have inserted
lots of hyperlinks, there is a quicker way – press Ctrl +
A (to select the whole document) and then press Ctrl +
6. |
Excel
Range Names
Naming a cell or a range of cells has a number of benefits; you
can use the names to navigate your document, the names can be used in formulas
and functions, and they are easier to remember than cell addresses. In addition,
the name will always refer to the cell(s), even if they are moved and it
is the equivalent of an Absolute cell reference |
| The easiest way to name a cell or range of cells is to select it and click
into the Name Box (to the left of the Formula Bar). Type
the name and press Enter. |
 |
| • If you have a data region with column and row headings,
you can make Excel use these as Range Names. Select the
region (click a cell and press Ctrl + ) and then click
Insert, Name, Create (2003) or Formulas
tab, Defined Names group, Create from Selection (2007).
Tick the appropriate boxes and click OK to apply |
| • You can make Excel update formulas with any new
Range Names by selecting the cells with the formulas and clicking
Insert, Name, Apply (2003) or in 2007, click any empty
cell, click the drop-down arrow next to Defined Names (Formulas
tab, Defined Names group) and Apply Names, OK. |
| • To use Range Names to navigate, click
the drop-down arrow in the Name Box and click the name. |
| Outlook |
| Delaying message delivery. |
| There may be occasions when you need to type an email message
but you don’t want to send it until later; maybe you are waiting for
confirmation of details for example, or perhaps you find yourself accidentally
clicking Send before you’d finished typing. |
| You can create a Rule to delay the sending
of messages for anything up to 120 minutes, either for all messages, or
just those matching specified criteria. |
| • From the Mail group window, select
Tools, Rules and Alerts, New Rule. |
| • Choose an After Sending rule, and
set any criteria you wish. If you don’t select criteria, the rule
will be applied to all messages, but Outlook will warn you that this is
the case. |
| • Select the option to Defer delivery by a number
of minutes and enter the length of delay you would like |
| • If there any regular exceptions, you can add these,
otherwise just name your Rule. |