Hyperlinking multiple files
 

Problem with hyperlinking multiple files. I have to link the information in
each row of the spreadsheet to its associated picture. Is there a way to do
that other than right clicking and adding a hyperlink in each cell since the
spreadsheets have 100+ entries? Some way to tell Excel to link to a folder
and just drag the file hyperlinks through the whole worksheet?

Hyperlinking multiple files
 

Have a look at worksheet function =HYPERLINK

HTH
--
AP

"Andrew Mongeon" a écrit dans le
message de ...
Problem with hyperlinking multiple files. I have to link the information
in
each row of the spreadsheet to its associated picture. Is there a way to
do
that other than right clicking and adding a hyperlink in each cell since
the
spreadsheets have 100+ entries? Some way to tell Excel to link to a
folder
and just drag the file hyperlinks through the whole worksheet?