Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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! |
#4
![]() |
|||
|
|||
![]()
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! |
#5
![]() |
|||
|
|||
![]()
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! |
#6
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide hyperlink cell & replace with macros | Excel Worksheet Functions | |||
how do I display a hyperlink in a seperate cell in excel? | Excel Discussion (Misc queries) | |||
Can not see all of a pasted paragraph from Word in a cell. | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
GET.CELL | Excel Worksheet Functions |