Editing Text and file location for Hyperlinks
 

Hi

I have a document that uses hyperlinks. At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text. This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

Is this possible?

Thanks

Editing Text and file location for Hyperlinks
 

Let's say you are creating the hyperlinks using:

Insert Hyperlink

and editting them the same way.

Instead, put the address in column A and the text in column B, then in C1
enter:

=HYPERLINK(A1,B1) and copy down. This will produce a nice "click-able"
table of hyperlinks. You can change the links anytime without having to use
the DialogBox.
--
Gary''s Student - gsnu200786


"forest8" wrote:

Hi

I have a document that uses hyperlinks. At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text. This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

Is this possible?

Thanks