Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 7th 05, 03:43 AM
mountainsun
 
Posts: n/a
Default Hyperlink ONE word in a cell ???

Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I have
stored photos. In the paragraph on worksheet 1 I want different words to link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then more
text and then there's a different hyperlinked photo HERE2 and some more text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!

  #2   Report Post  
Old April 7th 05, 04:08 AM
Ragdyer
 
Posts: n/a
Default

See If John's web page on this subject might help:

http://www.mcgimpsey.com/excel/lookuppics.html
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"mountainsun" wrote in message
...
Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I

have
stored photos. In the paragraph on worksheet 1 I want different words to

link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then

more
text and then there's a different hyperlinked photo HERE2 and some more

text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!


  #3   Report Post  
Old April 7th 05, 04:18 AM
Mohamed Shafiee
 
Posts: n/a
Default

Hi,

You could try using the drawing toolbar.

Shafiee.

"mountainsun" wrote in message
...
Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I
have
stored photos. In the paragraph on worksheet 1 I want different words to
link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then
more
text and then there's a different hyperlinked photo HERE2 and some more
text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!



  #4   Report Post  
Old April 7th 05, 05:13 AM
David McRitchie
 
Posts: n/a
Default

You will need to use two cells, as a cell can only have one link, and it
applies to the entire cell.

You may have seen this but it was probably in HTML that you saw it,
or you may have seen it in Microsoft Word, but certainly not in Excel.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mountainsun" wrote in message ...
Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I have
stored photos. In the paragraph on worksheet 1 I want different words to link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then more
text and then there's a different hyperlinked photo HERE2 and some more text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!



  #5   Report Post  
Old April 7th 05, 04:07 PM
mountainsun
 
Posts: n/a
Default

Thanks,

I have come to this conclusion and I will just stack multiple cells to match
the height of the cell with text wrap in it.
Thanks for the help!
Rick

"David McRitchie" wrote:

You will need to use two cells, as a cell can only have one link, and it
applies to the entire cell.

You may have seen this but it was probably in HTML that you saw it,
or you may have seen it in Microsoft Word, but certainly not in Excel.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mountainsun" wrote in message ...
Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I have
stored photos. In the paragraph on worksheet 1 I want different words to link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then more
text and then there's a different hyperlinked photo HERE2 and some more text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!






  #6   Report Post  
Old April 8th 05, 03:48 AM
Dave Peterson
 
Posts: n/a
Default

You could put a rectangle from the drawing toolbar over each word (format it
nicely to make it look invisible), then assign a different link to each of those
rectangles.

mountainsun wrote:

Is this possible?
Here's what I'm trying to do:

In worksheet 1 in cell A1 I have a paragraph of text. In worksheet 2 I have
stored photos. In the paragraph on worksheet 1 I want different words to link
to different photographs on worksheet 2 like this:

This is my sample text and here is my first hyperlinked PHOTO1 and then more
text and then there's a different hyperlinked photo HERE2 and some more text.

I'm pulling my hair out trying to figure this out as I thought I remember
being able to do this.
Thanks!


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide hyperlink cell & replace with macros Jose Excel Worksheet Functions 1 February 14th 05 09:23 AM
how do I display a hyperlink in a seperate cell in excel? Jose Excel Discussion (Misc queries) 1 January 12th 05 01:42 AM
Can not see all of a pasted paragraph from Word in a cell. Kat Excel Discussion (Misc queries) 2 December 23rd 04 07:37 PM
Hyperlink to word document problem JS Links and Linking in Excel 0 December 8th 04 11:54 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 05:57 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017