How do I get two lines within a row?

B

batdance

I know I can wrap text, but that doesn't work when the first line should be
shorter than the second and/or third.

I know there must be a character out there that drops you down to the next
line. I have been copying & pasting the space between one line and the next
on other people's documents so I can make it work on my documents, but there
must be a key or something people are typing to get that to work. Can someone
fill me in on this secret? It's such a mystery.
 
D

Dave Peterson

alt-enter will force a new line in a cell.

In a formula:
="some text" & char(10) & "some more"
(with wrap text turned on)
 
P

Pete

At the end of your line of text press <Alt><Enter> to force a new line
and keep doing this as you type the text in to give you more lines.

Hope this helps.

Pete
 
P

Philip Reece-Heal

When you want a carriage return in a cell, Hold down Alt key and hit Enter

Philip
 
Top