Posted by Ayush
I need some help with MS Excel. I want to know how can I split up cells. I've attached a screen shot of MS word where cells have been split up in a table..
Can someone tell me how can I do this in excel?
Posted by mrao
@ayush...merge the 3 blank cells above and below the cells with the text...there is no way of splitting a "cell" ..merging..yes...splitting a worksheet..yes...the pic you posted probably has a set of merged cells with the 3 cells with text left unmerged
Posted by ijefferies
Yep, MS is a pain here. All the cells need a discrete ref to function in the sheet, so splitting one cell into two or more new cells isn't possible.
Posted by Ayush
@m thanks for the intelligent solution
Posted by mrao
@a..a pleasure...
btw..you might wanna look up this website www.xltutor.com for tips on ms excel
Posted by Ayush
Thanks :-)