#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Cells

Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Cells

The reason I am asking is that I would like to have more than one hyperlink
located in the cell. I see in 2007 a hyperlink can be added to a text box,
but it isn't associated with the specific text in the text box, just the text
box itself. Therefore I have only been able to have one hyperlink per cell
or text box. I suppose I could fit two text boxes within one cell, but being
able to either split a single cell or assign more than one hyperlink to in a
cell or text box would be more helpful

"tdkosta" wrote:

Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Cells

On Jul 14, 9:12 am, tdkosta wrote:
Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?


What is the purpose of splitting the cell?

Explain the issue you are trying to resolve and someone may have a
solution.


N.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Cells

See the above I added a response to my original question to explain what I
wanted to do.

Thanks,
Tony

"Ginetta" wrote:

On Jul 14, 9:12 am, tdkosta wrote:
Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?


What is the purpose of splitting the cell?

Explain the issue you are trying to resolve and someone may have a
solution.


N.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Cells

On Jul 14, 10:52 am, tdkosta
wrote:
See the above I added a response to my original question to explain what I
wanted to do.

Thanks,
Tony

"Ginetta" wrote:
On Jul 14, 9:12 am, tdkosta wrote:
Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?


What is the purpose of splitting the cell?


Explain the issue you are trying to resolve and someone may have a
solution.


N.


http://exceltips.vitalnews.com/Pages..._a_Cell.ht ml

Check that document out. Is this what you are looking for?

Excel does not allow more than one hyperlink per cell. But this little
hack will let you sort of
get what you want.

Nick



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default Cells

Hi,

This cannot be done. Excel only allows you to enter hyperlinks on a
cell-by-cell basis.

Challa Prabhu

"tdkosta" wrote:

Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Cells

Instead of using a textbox, use a rectangle from the Forms toolbar. And format
each of the rectangles so that the borders are not visible.

tdkosta wrote:

The reason I am asking is that I would like to have more than one hyperlink
located in the cell. I see in 2007 a hyperlink can be added to a text box,
but it isn't associated with the specific text in the text box, just the text
box itself. Therefore I have only been able to have one hyperlink per cell
or text box. I suppose I could fit two text boxes within one cell, but being
able to either split a single cell or assign more than one hyperlink to in a
cell or text box would be more helpful

"tdkosta" wrote:

Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word?


--

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
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? excelnovice Excel Worksheet Functions 2 September 25th 05 12:38 AM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM
Pasting single cells from Word to multiple cells in Excel ASBiss Excel Worksheet Functions 1 February 15th 05 11:47 AM


All times are GMT +1. The time now is 12:16 AM.

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

About Us

"It's about Microsoft Excel"