G
Guest
Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
different cells)?
Ron Coderre said: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
Rednosebob said:Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
Ron Coderre said: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
Rednosebob said:Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
Pam said: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 said: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
Rednosebob said:Is it possible to have multiple hyperlinks in one cell (referencing say 5
different cells)?
Ron Coderre said: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 said: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 said: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)?
multiple cells - like a table within a cell?<<
Pam said: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 said: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 said: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
:
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)?