I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of and
reference Cell B...Not in a formula or anything like that. Just in general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

Yeah...I understand that David. But I thought you could actually split the
cell where there would be multiple rows. So each one of my kids's names would
be its own cell. I did a little digging and it doesn't seem as though that's
possible. The only suggestion I saw would be to underline the text to make it
appear as a separate row.

Thanks David. And just confirm if you can.

"David Biddulph" wrote:

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

Do you mean merge cells? Format/Cells/Alignment - Merge and Wrap Text.


"wnfisba" wrote:

Yeah...I understand that David. But I thought you could actually split the
cell where there would be multiple rows. So each one of my kids's names would
be its own cell. I did a little digging and it doesn't seem as though that's
possible. The only suggestion I saw would be to underline the text to make it
appear as a separate row.

Thanks David. And just confirm if you can.

"David Biddulph" wrote:

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

But if you do merge cells, please don't come back to us for sympathy when
you struggle with various Excel functions, such as sorting, filtering,
autofitting row height, etc. In general you'll find that the experts on
this group don't recommend merging cells.
--
David Biddulph

"JMB" wrote in message
...
Do you mean merge cells? Format/Cells/Alignment - Merge and Wrap Text.

"wnfisba" wrote:

Yeah...I understand that David. But I thought you could actually split
the
cell where there would be multiple rows. So each one of my kids's names
would
be its own cell. I did a little digging and it doesn't seem as though
that's
possible. The only suggestion I saw would be to underline the text to
make it
appear as a separate row.

Thanks David. And just confirm if you can.

"David Biddulph" wrote:

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part
of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

Select the cell with the kid's names and two empties below it.

EditFillJustify will drop the three names into 3 cells.


Gord Dibben MS Excel MVP

On Wed, 4 Apr 2007 15:44:01 -0700, wnfisba
wrote:

Yeah...I understand that David. But I thought you could actually split the
cell where there would be multiple rows. So each one of my kids's names would
be its own cell. I did a little digging and it doesn't seem as though that's
possible. The only suggestion I saw would be to underline the text to make it
appear as a separate row.

Thanks David. And just confirm if you can.

"David Biddulph" wrote:

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

I only use it occasionally for setting up headers (that I know are not
referenced in any formulae, macro, etc).


"David Biddulph" wrote:

But if you do merge cells, please don't come back to us for sympathy when
you struggle with various Excel functions, such as sorting, filtering,
autofitting row height, etc. In general you'll find that the experts on
this group don't recommend merging cells.
--
David Biddulph

"JMB" wrote in message
...
Do you mean merge cells? Format/Cells/Alignment - Merge and Wrap Text.

"wnfisba" wrote:

Yeah...I understand that David. But I thought you could actually split
the
cell where there would be multiple rows. So each one of my kids's names
would
be its own cell. I did a little digging and it doesn't seem as though
that's
possible. The only suggestion I saw would be to underline the text to
make it
appear as a separate row.

Thanks David. And just confirm if you can.

"David Biddulph" wrote:

Alt+Enter will allow you to insert a line feed in the cell.
--
David Biddulph

"wnfisba" wrote in message
...
I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part
of
and
reference Cell B...Not in a formula or anything like that. Just in
general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba

Hi,

Watch this video:

Split cell contents across multiple cells.

http://office.microsoft.com/en-us/ex...CL100570551033

Challa Prabhu

"wnfisba" wrote:

I thought I could split a cell...I'm just stupid and forget how.

For example, I want to split cell C into multiple rows that are part of and
reference Cell B...Not in a formula or anything like that. Just in general.
For example, my name in Cell B and then my kid's 3 names in Cell C.

Can I do this???

Thanks in advance.

wnfisba