If you want to have two columns for "Cat" you can merge the two cells, the
one that contains the title "Cat" and the next one. Then you'll have the two
columns under the same header

"Landy2130" wrote:

Thanks Gord. Thats was very clear and precise answer. So having said that how
would you go about having two headers for one column?

"Gord Dibben" wrote:

You cannot split a cell into multiple pieces and format each piece.


Gord Dibben MS Excel MVP

On Fri, 29 Dec 2006 08:02:01 -0800, Landy2130
wrote:

Just the "1 Cell" that has cat type in. Vertically in the same Column.

"Gary''s Student" wrote:

Do you want to split the cell horizontally, vertically or along the diagonal?
--
Gary''s Student


"Landy2130" wrote:

I was wondering is there anyway to split (half) just one cell in a
spreadsheet. For example: 3 colums 3 rows

Dog Cat Bird
Type
Color
Breed

Now I want to split the Cell Cat in half and have the capability to format
each half, w/o affecting the adjacent col and rows?.

Cat Size