Editing Text and file location for Hyperlinks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

forest8 - 17 May 2008 05:46 GMT

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

Reply to this Message

Gary''s Student - 17 May 2008 11:57 GMT

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.

Signature

Gary''s Student - gsnu200786

> Hi
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message