software

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.

PetePete
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

quot;Petequot; wrote:

gt; The formula to use is
gt;
gt; =HYPERLINK(actual_address, friendly_address)
gt;
gt; where actual_address is the full link to the website (or other excel
gt; sheets/files), and friendly_address is what is shown in the Excel cell
gt; - underlined and coloured blue. If friendly_address is missing, the
gt; actual_address is shown.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

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

contextures.com/xlDataEntry01.html

Neil wrote:
gt;
gt; Pete
gt; Thanks for this BUT
gt; I already have a list of all the 1,000 web addresses pasted into a column on
gt; the worksheet. I think youir method requires me to convert these to a
gt; formula on a line by line basis - i.e. 1,000 fomulae!! There must be a
gt; quicker, more global way? I know in the past I have disabled e-mail
gt; addresses from displaying as web addresses glovbally, is there a reverse of
gt; that process that will convert existing typed addresses to display and
gt; operate as hyperlinks??
gt; Neil
gt;
gt; quot;Petequot; wrote:
gt;
gt; gt; The formula to use is
gt; gt;
gt; gt; =HYPERLINK(actual_address, friendly_address)
gt; gt;
gt; gt; where actual_address is the full link to the website (or other excel
gt; gt; sheets/files), and friendly_address is what is shown in the Excel cell
gt; gt; - underlined and coloured blue. If friendly_address is missing, the
gt; gt; actual_address is shown.
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt; Pete
gt; gt;
gt; gt;

--

Dave Peterson