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

"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]

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