How to insert a hyperlink in text in a paragraph

D

duketter

Excel 2007 - Is it possible to add a hyperlink to only a couple words in an
entire sentence/paragraph in a cell. For example:
"Please review the test.doc to access the instructions for the file"

I only want the hyperlink on the test.doc words in the sentence, not the
entire sentence.
 
D

Dave Peterson

The Insert|Hyperlink type and the =hyperlink() type both apply to the entire
cell.

But you can cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) just over
the text you want. Then assign a hyperlink to that rectangle. Format the
characters under the rectangle so that it looks like a hyperlink (blue
underlined).
 
D

duketter

Thanks! That worked perfect.

Dave Peterson said:
The Insert|Hyperlink type and the =hyperlink() type both apply to the entire
cell.

But you can cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) just over
the text you want. Then assign a hyperlink to that rectangle. Format the
characters under the rectangle so that it looks like a hyperlink (blue
underlined).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top