Insert multiple hyperlinks at same time
 

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.

Insert multiple hyperlinks at same time
 

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.

Insert multiple hyperlinks at same time
 

Could you clarify that? Does that work if you have 100 different files and
you're trying to have 100 different links?

Sorry, just confused.

Thanks,

Jackie T


"Gary''s Student" wrote:

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.