| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change multiple hyperlinks at the same time | Excel Discussion (Misc queries) | |||
| insert a hyperlinks into a what-if equations | Excel Discussion (Misc queries) | |||
| Delete browsed pages under Insert Hyperlinks? | Setting up and Configuration of Excel | |||
| How do i allow users to insert hyperlinks into a protected sheet | Excel Discussion (Misc queries) | |||
| Remove Hyperlinks from multiple cells at the same time | Excel Discussion (Misc queries) | |||
Hybrid Mode
