Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeorgeD
 
Posts: n/a
Default How do I create different hyperlinks within one cell in Excel 2003

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I create different hyperlinks within one cell in Excel 2003

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).

Repeat for each link you need.

GeorgeD wrote:

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
GeorgeD
 
Posts: n/a
Default How do I create different hyperlinks within one cell in Excel

That seems to do the trick. Thanks a million Dave.

"Dave Peterson" wrote:

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).

Repeat for each link you need.

GeorgeD wrote:

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I create different hyperlinks within one cell in Excel

I have Office 2003.

This works great if you wrap the text but I need to have multiple hyperlinks
in a cell without wrapping the text. I have a lot of information in cell A-1
and it goes all the way down to Y or Z column or whatever. If I double click
the cell then I can see all the info in A-1 instead of it going all the way
down. Is there a way to make certain text within a cell a hyperlink without
inserting a shape? Or, is there a way to insert a shape into a cell instead
of it being "on top" of the cell?

Please reply in detail. I am not the most technical person in the world but
I do know a little! :-)

Thanks in advance!


"Dave Peterson" wrote:

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).

Repeat for each link you need.

GeorgeD wrote:

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I create different hyperlinks within one cell in Excel

You can use Insert|Hyperlink to add a hyperlink to a cell.

You can put shapes over the cell (not in it) and assign different hyperlinks to
each shape.

I don't know a way to accomplish what you want. I'd bet that there isn't a
way. (But I've been wrong before.)


SREESE wrote:

I have Office 2003.

This works great if you wrap the text but I need to have multiple hyperlinks
in a cell without wrapping the text. I have a lot of information in cell A-1
and it goes all the way down to Y or Z column or whatever. If I double click
the cell then I can see all the info in A-1 instead of it going all the way
down. Is there a way to make certain text within a cell a hyperlink without
inserting a shape? Or, is there a way to insert a shape into a cell instead
of it being "on top" of the cell?

Please reply in detail. I am not the most technical person in the world but
I do know a little! :-)

Thanks in advance!

"Dave Peterson" wrote:

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).

Repeat for each link you need.

GeorgeD wrote:

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I create different hyperlinks within one cell in Excel

I figured it was a long shot because I've been all over trying to get an
answer. Maybe there is someone else out there that knows or maybe Microsoft
will add this feature?? I hope so!

Thanks for your repy!

"Dave Peterson" wrote:

You can use Insert|Hyperlink to add a hyperlink to a cell.

You can put shapes over the cell (not in it) and assign different hyperlinks to
each shape.

I don't know a way to accomplish what you want. I'd bet that there isn't a
way. (But I've been wrong before.)


SREESE wrote:

I have Office 2003.

This works great if you wrap the text but I need to have multiple hyperlinks
in a cell without wrapping the text. I have a lot of information in cell A-1
and it goes all the way down to Y or Z column or whatever. If I double click
the cell then I can see all the info in A-1 instead of it going all the way
down. Is there a way to make certain text within a cell a hyperlink without
inserting a shape? Or, is there a way to insert a shape into a cell instead
of it being "on top" of the cell?

Please reply in detail. I am not the most technical person in the world but
I do know a little! :-)

Thanks in advance!

"Dave Peterson" wrote:

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).

Repeat for each link you need.

GeorgeD wrote:

I need to have different items in the same cell(in Excel 2003), linking to
different areas within the Excel doc. Basically, I need to have numerous
hyperlinks within one cell. However, I only seem to be able make a link out
of an entire cell. I there any way around this?

--

Dave Peterson


--

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
Office 97 hyperlinks do not work in excel 2003 RonanM Excel Discussion (Misc queries) 0 October 26th 05 03:03 PM
how to create interactive US map in excel 2003 Desparate Charts and Charting in Excel 1 July 10th 05 08:32 PM
How do you create a drop-down menu within a cell in Excel? Jimmy Excel Discussion (Misc queries) 1 March 21st 05 04:14 PM
combined cell data from Excel to Word (2003) Adam Excel Discussion (Misc queries) 2 February 14th 05 04:29 PM
How do I create a geographic map in Excel 2003? cain Excel Worksheet Functions 1 December 6th 04 11:29 PM


All times are GMT +1. The time now is 09: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"