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

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


"Rednosebob" wrote:

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

It does what I needed. Thanks a bunch!

"Ron Coderre" wrote:

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


"Rednosebob" wrote:

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

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




"Ron Coderre" wrote:

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


"Rednosebob" wrote:

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

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


"Pam" wrote:

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




"Ron Coderre" wrote:

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


"Rednosebob" wrote:

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

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




"Ron Coderre" wrote:

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


"Pam" wrote:

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




"Ron Coderre" wrote:

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


"Rednosebob" wrote:

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

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


"Pam" wrote:

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




"Ron Coderre" wrote:

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


"Pam" wrote:

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




"Ron Coderre" wrote:

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


"Rednosebob" wrote:

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