Apple Numbers '09 - Manual (Page 188)

To add hypertext that links to an email message:
1 Select the text that you want to turn into a hyperlink.
If you include an email address in a spreadsheet, the text automatically becomes a
hyperlink. To turn off this feature, choose Numbers > Preferences, click Auto-Correction,
and then deselect “Automatically detect email and web addresses.” This setting is
computer specific, so if the spreadsheet is edited on a computer with a different
setting, that computer’s setting is used instead.
2 Click Inspector in the toolbar, click the Hyperlink inspector button, and then select
“Enable as a hyperlink.”
3 Choose Email Message from the Link To pop-up menu.
4 Type the email address of the intended recipient in the To field.
5 Optionally type a subject line in the Subject field.
Type the email address of
the message recipient.
Type the message subject.
You can also quickly create a hyperlink using the Insert menu. Place an insertion point
somewhere in your spreadsheet, and choose Insert > Hyperlink > Email Message.
A link is added to your spreadsheet and the Hyperlink inspector opens. Type the email
address in the To field.
Editing Hyperlink Text
There are several ways to edit hyperlink text.
Here are ways to edit hyperlink text:
Deactivate hyperlinks so that they can be edited without activating the link.
m
Click Inspector in the toolbar, click the Hyperlink inspector button, select “Make all
hyperlinks inactive”, edit the text, and then reactivate the link.
Click outside the hyperlink text, and use the arrow keys to move the insertion point
m
into the text.
Inserting Page Numbers and Other Changeable Values
You can insert values such as page numbers, page count, filename, and date and time
in a spreadsheet by using formatted text fields, which are automatically updated by
Numbers when these values change. Although values such as these are common in
headers and footers (see “Adding Headers and Footers to a Sheet” on page 44), you can
insert formatted text fields anywhere in your spreadsheet.
188 Chapter 8 Working with Text