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

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.

tshad wrote:

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

Paste into the formula bar after turning on wrap text in
formattingalignment


--


Regards,


Peo Sjoblom


"tshad" wrote in message
...
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