How do I format text as a hyperlink in Excel

G

Guest

I want up to 1,00o cells in a single Excel worksheet to display as hyperlinks
to general web addresses (mainly home pages). Each cell is a different web
address. How do I format the Excel cells to display and act as a hyperlink?
 
P

Pete

The formula to use is

=HYPERLINK(actual_address, friendly_address)

where actual_address is the full link to the website (or other excel
sheets/files), and friendly_address is what is shown in the Excel cell
- underlined and coloured blue. If friendly_address is missing, the
actual_address is shown.

Hope this helps.

Pete
 
G

Guest

Pete
Thanks for this BUT
I already have a list of all the 1,000 web addresses pasted into a column on
the worksheet. I think youir method requires me to convert these to a
formula on a line by line basis - i.e. 1,000 fomulae!! There must be a
quicker, more global way? I know in the past I have disabled e-mail
addresses from displaying as web addresses glovbally, is there a reverse of
that process that will convert existing typed addresses to display and
operate as hyperlinks??
Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top