How do I turn 1 cell into 2 cells without adding columns or rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawna - 30 May 2008 20:36 GMT

Is it possible to divide a cell into more than one cell without adding rows
or columns to the worksheet? I need to be able to apply borders to the new
cells created.

Reply to this Message

Dave - 30 May 2008 21:31 GMT

Hi,
Sorry, you can't split basic cells in Excel.
You can add a diagonal line in Format > Cells > Borders, which is the
closest you'll get.
The other approach is to merge all cells across 2 columns, then un-merge
just the ones you want to "split." But merging can create other problems when
trying to manipulate data and layout.
Regards - Dave.

Reply to this Message

Shawna - 30 May 2008 22:34 GMT

I was afraid of that. Thanks for your help.

> Hi,
> Sorry, you can't split basic cells in Excel.
[quoted text clipped - 4 lines]
> trying to manipulate data and layout.
> Regards - Dave.

Reply to this Message