How do I format text as a hyperlink in Excel

[Neil]

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?

 

[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

 

[Neil]

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

 

[Dave Peterson]

Take a look at Debra Dalgleish's site to learn how to copy that formula down the
range you need:

http://contextures.com/xlDataEntry01.html