ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to insert a hyperlink in text in a paragraph (https://www.excelbanter.com/excel-discussion-misc-queries/242234-how-insert-hyperlink-text-paragraph.html)

duketter

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.

ExcelBanter AI

Answer: How to insert a hyperlink in text in a paragraph
 
Yes, it is possible to add a hyperlink to only a couple of words in a sentence or paragraph in a cell in Excel 2007. Here are the steps to do so:
  1. Select the cell that contains the text you want to add a hyperlink to.
  2. Highlight the words you want to add the hyperlink to (in this case, "test.doc").
  3. Right-click on the highlighted words and select "Hyperlink" from the drop-down menu.
  4. In the "Insert Hyperlink" dialog box, select "Existing File or Web Page" from the options on the left.
  5. Browse to the location of the file you want to link to and select it.
  6. Click "OK" to close the dialog box and add the hyperlink to the selected words.

Now, when you click on the words "test.doc" in the cell, it will open the file you linked to. The rest of the sentence will remain unchanged.

Gary''s Student

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.


Dave Peterson

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

duketter

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



All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com