Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HYPERLINKING WITHIN A SINGLE SHEET Gwyndalf Excel Worksheet Functions 1 November 19th 06 11:21 PM
Extracting multiple entries in a cell into their component pieces Bob Excel Worksheet Functions 15 June 21st 06 01:07 AM
combining 2 pieces of text from 2 columns alexy Excel Worksheet Functions 3 September 15th 05 10:35 AM
looking for range of text in a single cell hatter Excel Discussion (Misc queries) 0 August 29th 05 06:23 PM
single text cells combines in new text cell toad32 Excel Discussion (Misc queries) 2 June 7th 05 01:17 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"