Set up many cells within a cell

  • Thread starter Thread starter jrps
  • Start date Start date
Hi Bernard,
As in Word function, I want to divide an Excel cell into many cells so that
add data without changing row.

Thanks.
 
Cells cannot be split; they can be merged (Merge & Center tool) horizontally
and vertically
To get multiple lines of text (no border line in between) in one cell:
type CAT, then ALT+ENTER, then DOG
Hope this helps
best wishes
 
A cell is defined as the intersection between a row and a column. [That's
where the cell references come from.]
You can't insert extra cells without inserting extra rows and/or columns.
 
As Word function I just want to split a cell into many cells so that I can
add data without changing the row.
Is it possible in Excel 2003?

Thank you.

David Biddulph said:
A cell is defined as the intersection between a row and a column. [That's
where the cell references come from.]
You can't insert extra cells without inserting extra rows and/or columns.
--
David Biddulph

jrps said:
Hi Bernard,
As in Word function, I want to divide an Excel cell into many cells so
that
add data without changing row.

Thanks.
Click to expand...
Click to expand...
 
As Word function I just want to split a cell into many cells so that I can
add data without changing the row.
Is it possible in Excel 2003?

Thank you.
Click to expand...

As mentioned, you can't split/add cells without "changing the row".
That's the same thing.

If you have several items in one cell and want to split those to other
cells, check out "Text To Columns" in the Data menu.
 
Back
Top