Hello,
I have a list of web sites in a spreadsheet in Microsoft Excel. Each
cel has a website listed like this:
www.website1.com
www.website2.com
www.website3.com
etc.
If I double click on each individual line of "text" it turns blue and
into a "link". I want them all to be "links" and I don't want to have
to double click each one individually. It is too much work. How do I
change the entire column into links?
The version of Excel that came with my Windows 2000 is 10.2614.2625.
John |
Request for Question Clarification by
hummer-ga
on
02 Apr 2005 18:55 PST
Hi johnjri1,
Assuming your URLs are in column A, make a new column B and insert the
formula =HYPERLINK(A1) in B1.
Go to B1.
Click "Paste Function" button.
Select "Hyperlink" and click OK.
Type: "A1" for "Link Location" and click OK.
You should now have A1's URL in B1 and it should be clickable.
Now copy B1.
Select the rest of the column under B1 down as far a column A goes.
Paste.
If all went well, all of your URLs in column B should be clickable.
Unfortunately, you won't be able to delete column A.
Please let me know if this is a suitable solution.
hummer
|
Clarification of Question by
johnjri1-ga
on
03 Apr 2005 08:29 PDT
Hummer,
I did exactly as you suggested. At first when I entered the fomula
=HYPERLINK(A1) I was encouraged to see it turn blue. However when I
clicked on it, I got the following 'Microsoft Excel' pop-up prompt:
"The address of this site is not valid. Check the address and try
again. I have since tried this again and again, all the time using
www.google.com.
So then I figured, maybe my computer has a problem, so I tried this on
a different computer, my laptop running XP as opposed to 2000, and got
the *exact same results including the identical verbatim pop-up.
I have noticed another peculiarity since I originally posted the question:
The list of websites I have in the spreadsheet was copied and pasted
from another source. When I copy and paste the website(s) (example:
www.google.com)they do not automaticly highlight, however if I double
click on each individual cell , as I originally stated,(I actually
have to double click it, then highlight any other random cel, for it
to turn into a hyperlink) it does highlight and become a working link.
However when I type the website manually into a cel (www.google.com),
it automatically highlights and becomes a working link without the
need to double-click.
It is my intention to continue copying and pasting 100's of websites
at a time for this project.
Best Regards,
John
|
Request for Question Clarification by
hummer-ga
on
03 Apr 2005 08:49 PDT
Hi John,
Just to clarify (because it should work) -
COL A
A1 www.google.com
A2 www.tootle.com
A3 www.doodle.com
COL B
A1 =HYPERLINK(A1) (via "function")
Copy Col B, A1
Highlight Col B, A2 & A3
Paste
The three URLs in Col A should magically appear in Col B as clickable links.
Regards,
hummer
|
Request for Question Clarification by
hummer-ga
on
03 Apr 2005 08:57 PDT
John, how are you with macros?
Excel Help Forum > Usenet Groups > Excel Worksheet Functions >
Changing text to hyperlink
http://www.excelforum.com/archive/index.php/t-238194.html
hummer
|
Clarification of Question by
johnjri1-ga
on
03 Apr 2005 09:46 PDT
"If new to VBA and Macros, visit David's "getting started" site.
http://www.mvps.org/dmcritchie/excel/getstarted.htm"
Hummer,
Thanks for your patience. When I get a chance I'll vist the above
site. I feel confident that this is the solution.
Please, consider this question answered.
Thanks again,
John
|
Request for Question Clarification by
hummer-ga
on
03 Apr 2005 10:30 PDT
Dear John,
Thank you for your kind note. I'll post the answer but I'd feel better
doing it after you've had success. If you need help with the macro,
I'm afraid I'm not the one to ask. I suppose we could always work it
out together - two heads are better than one.
Good luck!
hummer
|
