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?

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

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

"Pete" wrote:

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

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

Neil wrote:

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

"Pete" wrote:

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



--

Dave Peterson