A previous nembers had a nifty feture to disable clickability of all hyperlinks, making them easy to edit. Or you could enable click ability. That is what I want to do now. I have a column for links, they are blue underlined but not clickable. how do I make all links in this column clickable?
I searched help and the menus but found no such feature.
Found it under
Edit>Substitutions>Smart Links.
Strange terminology.
Hi Gnarlodious,
From the Formulas and Functions User Guide (Numbers '09). This function still works in Numbers 3.
HYPERLINK
The HYPERLINK function creates a clickable link that opens a webpage or new email message.
HYPERLINK(url, link-text)
 url: A standard universal resource locator. url is a string value that should contain a properly formatted universal resource locator string.
 link-text: An optional value that specifies the text that appears as a clickable link in the cell. link-text is a string value. If omitted, url is used as the link-text. Examples =HYPERLINK(”http://www.apple.com”, “Apple”) creates a link with the text Apple that opens the default web browser to the Apple homepage. =HYPERLINK(”mailto:janedoe@example.com?subject=Quote Request”, “Get Quote”) creates a link with the text Get Quote that opens the default email application and addresses a new message to janedoe@example.com with the subject line Quote Request.
C2 (and Fill Down)
=HYPERLINK(B2)
Regards,
Ian.
Make all URLs clickable
