ExcelBanter - Split cells

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Split cells (https://www.excelbanter.com/new-users-excel/184534-split-cells.html)

Elaine

Split cells

In Excel 2007, how do I split one cell into several rows?

Peo Sjoblom

Split cells

If you mean when you type, then you can press alt + enter for a new line
within the same cell.

--

Regards,

Peo Sjoblom

"Elaine" wrote in message
...
In Excel 2007, how do I split one cell into several rows?

Elaine

Split cells

"Peo Sjoblom" wrote:

If you mean when you type, then you can press alt + enter for a new line
within the same cell.

I typed in the cell and then selected ALT+Enter and nothing happened. Did I miss an important step?
--

Regards,

Peo Sjoblom

"Elaine" wrote in message
...
In Excel 2007, how do I split one cell into several rows?

help

Split cells

After you type in the cell Do not press enter
PRess ALt+Enter
that will make a new line

"Elaine" wrote:

"Peo Sjoblom" wrote:

If you mean when you type, then you can press alt + enter for a new line
within the same cell.

I typed in the cell and then selected ALT+Enter and nothing happened. Did I miss an important step?
--

Regards,

Peo Sjoblom

"Elaine" wrote in message
...
In Excel 2007, how do I split one cell into several rows?

All times are GMT +1. The time now is 04:01 AM.