Insert Hyperlink Command

[ashton]

Hello,

I have a spreadsheet that needs to be burned to a CD. This spreadsheet is
going to have a list of file names (files included on the cd) and it would be
nice to give the user the ability to click on the file name and have the file
automatically open up.

This is no problem, I can go Insert->Hyperlink->File

The problem is I need to do this for 2,000 rows

Is there a faster way to insert all of these file names and paths? My
spreadsheet has all of the file names in one row, is there a way to
mass-hyperlink all of these file names?

Any help would be appreciated

 

[Bernie Deitrick]

Ashton,

Try using the HYPERLINK worksheet function, with your file name/path as the
first parameter/argument Set it up for one row, then simply copy down to
match your list.

HTH,
Bernie
MS Excel MVP

 

[ashton]

Perfect! Thank You!

Ashton,

Try using the HYPERLINK worksheet function, with your file name/path as the
first parameter/argument Set it up for one row, then simply copy down to
match your list.

HTH,
Bernie
MS Excel MVP