Multiple lines in a cell
 

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

Multiple lines in a cell
 

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

Multiple lines in a cell
 

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