View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Adding Multiple Hyperlinks to Excel

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
toolsautocorrectauto format as you typecheck 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
specialformat.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


" wrote:

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