Cells

[Guest]

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

 

[Guest]

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

 

[Ginetta]

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.

 

[Guest]

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

Thanks,
Tony

 

[Ginetta]

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

Thanks,
Tony

http://exceltips.vitalnews.com/Pages/T0800_Putting_More_than_One_Hyperlink_in_a_Cell.html

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

 

[Guest]

Hi,

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

Challa Prabhu

 

[Dave Peterson]

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.