Multiple lines in a cell

[tshad]

In Excel 2007, how do you put multiple lines in a cell?

I have some text that I want to paste in a cell that span muliple lines or
type them in. But when I do, it goes to the next cell. If pasting, it puts
them in the cells below. One cell per line.

I am trying to put some status information that shows what the possible
statuses are in a database and want the statuses to show in the same cell.

Can you do this? Wrapping won't do it.

Thanks,

Tom

 

[Dave Peterson]

If you're typing in the text, you can hit alt-enter to force a new line within
the cell.

If you're typing a formula, you can use:
="Top"&char(10)&"bottom"
And format the cell to wrap text.

If you're trying to paste multilined text into a single cell, paste directly
into the formulabar--not the cell itself.

 

[Peo Sjoblom]

Paste into the formula bar after turning on wrap text in
formatting>alignment


--


Regards,


Peo Sjoblom