Adding Multiple Hyperlinks to Excel

  • Thread starter Thread starter vincecarone
  • Start date Start date
V

vincecarone

I have 1315 rows in Excel. They are B2 through B1315

I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink. I don't want to have to do this one by one. Does anybody
know a way to do them all at the same time? Please simplify
instructions.

Thank you
Vince
 
Put something like this in C2 and drag down:

=hyperlink(b2,b2)
or
=hyperlink("http://" & b2, b2)
 
If your weblinks are written correctly like www.google.co.uk you can change
them First make sure the auto correct for web links, check
tools>autocorrect>auto format as you type>check internet and network paths.
type in a web address in a cell like www.google.co.uk (should change to a
hyperlink), copy this cell and then select your row or column and paste
special>format.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top