A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to insert a hyperlink in text in a paragraph



 
 
Thread Tools Display Modes
  #1  
Old September 10th 09, 02:46 PM posted to microsoft.public.excel.misc
duketter
external usenet poster
 
Posts: 63
Default How to insert a hyperlink in text in a paragraph

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.
Ads
  #2  
Old September 10th 09, 03:00 PM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 11,059
Default How to insert a hyperlink in text in a paragraph

Not within a single cell. It is easy in Word or PowerPoint.
--
Gary''s Student - gsnu200903


"duketter" wrote:

> 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.

  #3  
Old September 10th 09, 04:02 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default How to insert a hyperlink in text in a paragraph

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).



duketter wrote:
>
> 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.


--

Dave Peterson
  #4  
Old September 10th 09, 07:25 PM posted to microsoft.public.excel.misc
duketter
external usenet poster
 
Posts: 63
Default How to insert a hyperlink in text in a paragraph

Thanks! That worked perfect.

"Dave Peterson" wrote:

> 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).
>
>
>
> duketter wrote:
> >
> > 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.

>
> --
>
> Dave Peterson
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to hyperlink to a paragraph in a word file? ViestaWu Excel Discussion (Misc queries) 3 June 26th 08 01:01 PM
How do I set up a hyperlink to a word in a paragraph? Carlos Valdez Excel Discussion (Misc queries) 3 January 29th 08 10:00 PM
How to insert from name range into a paragraph? misterno Excel Worksheet Functions 2 March 9th 07 03:52 PM
insert a paragraph break within text in a singel cell? Julie Excel Discussion (Misc queries) 3 September 29th 06 05:35 PM
HYPERLINK - insert within a text sentence Jane Excel Worksheet Functions 1 September 22nd 06 06:07 PM


All times are GMT +1. The time now is 11:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.