Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to split a single cell into multiple cells similar to
splitting a table cell in MS Word? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |