Multiple hyperlinks

[Mustard]

I have multiple files that i want to put a hyperlink to. Rather than doing it
one by one, is there a quick way to just automatically add a hyperlink to all
files?

 

[David McRitchie]

To make it easier for someone to help you a few examples of what
you want to link to would be helpful, fortunately you can probably
find your an answer on one of my pages.
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
and perhaps a solution something like:
=HYPERLINK("file://x:/mywebsite/dmcritchie/excel/" & A6 & ".htm",A6)
or something like
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp2