Dear Pros,
I am trying to SPLIT A CELL into 2 in excel 2007. I have gone to help online but the issue is I could not find TABLE LAYOUT. I am sure you will help me out.

Thanks.

You cannot split an empty, unmerged cell. You can only split a cell that was previously merged. However, you can split the contents of an unmerged cell and distribute the divided contents across other cells.

Clarify your needs better. I only have a vague idea of what I think you need: Something like a header column with two sub-cell beneath it? If yes, then what you need to do is merge the topmost cells as one. See the attached sample.xls file if it offers what you need.

Regards.

Thank you @Maleeq, I raised two questions.
1. I did not see TABLE LAYOUT on my toolbar that made it impossible for me to
2. get to SPLIT A SINGLE CELL- I want to have 2 colors in a cell with content (NO MERGING).

Thanks & regards.

Hi STOjo,

#1. The "Table Layout" simply does not exist in excel. Excel, as-is, is a table already whose layout cannot be altered.
#2. Its not possible to achieve that in excel without a merge.