Not possible and neither is a good way to design in Excel, what you
basically do is that you split one cell so it would look like

cell1|cell2
c e l l 3

if you would translate that to excel it means that cell3 becomes merged and
it causes a lot of problems. You can check that by making a table in word
like than and then paste it into excel




















pasted into A1 will make row 2 merged and there is no practical use of
having that in a spreadsheet except for looks. You can't calculate normally
using formulas that take ranges. You can't paste in a range of values
without getting messages like "cannot change part of a merged cell"


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Kjandar" wrote in message
...
Click in a cell, or select multiple cells that you want to split.
On the Table menu, click Split Cells .
Select the number of columns or rows you want to split the selected cells
into. This is the information I get in MS Word 2003, but cannot find the
function in MS Excel 2003, can someone help?