ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinking two different pieces of text in a single cell (https://www.excelbanter.com/excel-discussion-misc-queries/156351-hyperlinking-two-different-pieces-text-single-cell.html)

GregJ

Hyperlinking two different pieces of text in a single cell
 
I am creating a curriculum based master calendar in which certain cells will
have multiple meeting times by different departments for the same day. I want
to be able to link one department (X) to Y document and (Z) department to A
document

Each of these two departments appear in the same cell, when I try to link
the text for department x to it's document the insert HL is greyed out and
not available....is there something I am doing wrong?



Dave Peterson

Hyperlinking two different pieces of text in a single cell
 
If you're really careful, you could put a couple rectangles over each
word/phrase, then assign a different hyperlink to each of those rectangles.

If you hide the borders, it may look ok (and format the words/phrases so that
they look like links, too).

Gregj wrote:

I am creating a curriculum based master calendar in which certain cells will
have multiple meeting times by different departments for the same day. I want
to be able to link one department (X) to Y document and (Z) department to A
document

Each of these two departments appear in the same cell, when I try to link
the text for department x to it's document the insert HL is greyed out and
not available....is there something I am doing wrong?


--

Dave Peterson


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com