View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KK KK is offline
external usenet poster
 
Posts: 12
Default multiple hyperlinks

Hello,

I have Excel 2007 running under Vista

I have a spreadsheet which lists in a column all the files in a certain
folder. I am trying to create a hyperlink between the spreadsheet entries
and the files themselves.

I know how to do this using the 'hyperlink' option, or Ctrl-K, but it is a
very slow process as I have to link files one by one.

Is there a way of linking several files simultaneously ? (I have tried
selecting a group of cells but they all link to the same file)

Thanks for all advice

KK