Turning Cell into Hyperlink

[pgflrob]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a column in spreadsheet that has URLs. I would like to turn them into hyperlinks so I can go directly to the webpage from Excel.

If I type in the URL or if I go cell by cell and use CMD-K I can do it but is seems like there should be a way to select a bunch of cells with URLs and convert them from text to hyperlink.

Can someone help?

 

[John McGhie]

Did you search this group for "Hyperlink"?

There are several postings describing the process in exact detail. I don't
feel like typing them all out again for yo9u.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I have a column in spreadsheet that has URLs. I would like to turn them into
hyperlinks so I can go directly to the webpage from Excel.

If I type in the URL or if I go cell by cell and use CMD-K I can do it but is
seems like there should be a way to select a bunch of cells with URLs and
convert them from text to hyperlink.

Can someone help?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

There is no 'single click' method for batch processing -- each cell's target
has to be individually specified. This has recently been described several
times in the group. Search on the term 'hyperlink'.

Regards |:>)
Bob Jones
[MVP] Office:Mac