making a column with working hyperlinks?

  • Thread starter Thread starter Robert Anderson
  • Start date Start date
R

Robert Anderson

I was wondering if there is a setting to make it so the hyperlinks in a
column would be real hyperlinks and not just text?

I looked at formatting and did not see anything there.
 
Hi there,

Ctrl + K will bring up the Insert Hyperlink dialog box. You can navigate
there by going to the Insert (menu) | Hyperlink. Or you can make use of the
HYPERLINK function. An example would look like this ..

=HYPERLINK("http://www.vbaexpress.com/forum/","MyWebSite.com")
 
zackb said:
Hi there,

Ctrl + K will bring up the Insert Hyperlink dialog box. You can navigate
there by going to the Insert (menu) | Hyperlink. Or you can make use of
the HYPERLINK function. An example would look like this ..

=HYPERLINK("http://www.vbaexpress.com/forum/","MyWebSite.com")
Click to expand...

insert > hyperlink is grayed and what I am looking for is not inserting
individual hyperlink.

I want the whole column so when I type in http://www.whatevertheurl.com it
is automatically a hyperlink instead of just text.

Thanks.
 
What version of excel are you using?

This is the default behavior in xl97+, but in xl2002+ (IIRC), it can be turned
off by:
tools|autocorrect options|autoformat as you type tab

Make sure that "Replace as you type" option for hyperlinks is checked.
 
Hi Robert,
Do you mean something like:

A2: 'ibm
B2: =HYPERLINK("http://www." & A2 & ".com",A2)
A3: 'microsoft
B3: =HYPERLINK("http://www." & A3 & ".com",A3)

since Column A has the name, there is no need to repeat it
in Column B to invoke the link -- most companies would be more than
three initials.
B2: =HYPERLINK("http://www." & A2 & ".com","lnk")
B3: =HYPERLINK("http://www." & A3 & ".com","lnk")
 
Dave Peterson said:
What version of excel are you using?

This is the default behavior in xl97+, but in xl2002+ (IIRC), it can be
turned
off by:
tools|autocorrect options|autoformat as you type tab

Make sure that "Replace as you type" option for hyperlinks is checked.
Click to expand...

Both are "Replace as you type" options are already checked...
 
So when you type:
http://www.whatevertheurl.com
it's not converted to a hyperlink?

Does it happen in all your workbooks this way?
If you start excel in safe mode:
close excel
windows start button|Run
Excel /safe

Does it work correctly?

(I don't have a real good guess why it doesn't work for you.)
 
Back
Top