Multiple hyperlinks in one cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rednosebob - 05 Dec 2005 19:56 GMT

Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?

Reply to this Message

Ron Coderre - 05 Dec 2005 20:19 GMT

Try this:
Assuming they are all in the same worksheet, select those cells and give
them a range name:
In the Name box (just above the Col_A heading) type: rngMultiCells, then
press [Enter]

Then, select your hyperlink cell.
Insert>Hyperlink
Click: Place in this document
Select the range named rngMultiCells
Click [OK]

Now, when you click the hyperlink....those cells should all be selected.

Does that help?

***********
Regards,
Ron

> Is it possible to have multiple hyperlinks in one cell (referencing say 5
> different cells)?

Reply to this Message

Rednosebob - 05 Dec 2005 21:02 GMT

It does what I needed. Thanks a bunch!

> Try this:
> Assuming they are all in the same worksheet, select those cells and give
[quoted text clipped - 18 lines]
> > Is it possible to have multiple hyperlinks in one cell (referencing say 5
> > different cells)?

Reply to this Message

Pam - 02 Nov 2006 18:12 GMT

Ron,
I know this is an older post, but I have the same problem - I need to create
multiple links in 1 merged cell in a workbook I've saved as a .mht web file.

I've created an index and want to have an alphabet listing at the top so
that when you click on the letter you're linked to the first cell in that
section that starts with that letter. I saw your answer and, although I'm
not a beginner in Excel, I don't understand how to apply it to my situation.
Can you elaborate?

Example:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A items run from B8 - B 20
B items run from B22 - B 25
C items run from B27 - B33

and so on.

I've tried creating a table in Word, pasting it as a Metafile, and adding
hyperlinks to each of those cells, but in the web view, their link shows as
#RANGE!B8 where B8 is the destination cell.

Thank you for any assistance you can provide.
Pam

Reply to this Message

Ron Coderre - 02 Nov 2006 19:01 GMT

Sorry, Pam....as soon as you publish the workbook as a web page, it appears
that Excel can't convert from a hyperlink to a cell to a hyperlink to a
bookmark. Perhaps you'd need to open the mht in an HTML editor and add the
bookmarks and links there. I can't think of any alternatives.

***********
Regards,
Ron

XL2002, WinXP

> Ron,
> I know this is an older post, but I have the same problem - I need to create
[quoted text clipped - 45 lines]
> > > Is it possible to have multiple hyperlinks in one cell (referencing say 5
> > > different cells)?

Reply to this Message

Pam - 02 Nov 2006 20:29 GMT

Thank you Ron. One last question... Is it possible to divide 1 cell into
multiple cells - like a table within a cell? That's the only other way I can
think of to accomplish what I'm attempting.
Thanks,
Pam

> Sorry, Pam....as soon as you publish the workbook as a web page, it appears
> that Excel can't convert from a hyperlink to a cell to a hyperlink to a
[quoted text clipped - 56 lines]
> > > > Is it possible to have multiple hyperlinks in one cell (referencing say 5
> > > > different cells)?

Reply to this Message

Ron Coderre - 02 Nov 2006 20:36 GMT

>> Is it possible to divide 1 cell into
> multiple cells - like a table within a cell?<<

Not really....unless you count using [alt]+[enter] to put line feeds in the
cell.
(Maybe a Data Validation List would do what you want?)

Create a new topic and describe what you're hoping to do. If it can be
done...this is the pool of talent that would know. :)

***********
Regards,
Ron

XL2002, WinXP

> Thank you Ron. One last question... Is it possible to divide 1 cell into
> multiple cells - like a table within a cell? That's the only other way I can
[quoted text clipped - 62 lines]
> > > > > Is it possible to have multiple hyperlinks in one cell (referencing say 5
> > > > > different cells)?

Reply to this Message