Say column A contains the list of documents:

C:\Documents and Settings\User\Desktop\book1.xls

In a helper column enter:

=HYPERLINK("file:\\\" & A1,A1)

and copy down. This will produce a nice table of hyperlinks
--
Gary''s Student - gsnu200752


"AmyO" wrote:

I want to create a row for each document. I have over 100 documents I want
to link to. Does anyone know how to create many hyperlinks at one time
rather than just 1 at a time? I am using Excel 2007.