Excel - How do I fit 2 lines of text in one cell, vs a long line?

[Guest]

Excel - How do I fit 2 lines of text in one cell, vs a long line?

Example:
I need to fit a lot of things in one row
but I hate scrolling all the way over

....As opposed to:
I need to fit a lot of things in one row but I hate scrolling all the way
over

 

[Bob Phillips]

Break the lines with Alt-Enter

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron Coderre]

You can insert a "carriage return" in text this way:

Hold down the [Alt] key and press [Enter]

Example using:
I need to fit a lot of things in one row but I hate scrolling all the way
over.

Edit the cell and place the cursor after the word "row"
then....[Alt]+[Enter]
Press [Enter] to finish.

After adjust the column wideht, the text now wraps in the cell and looks
like this:
I need to fit a lot of things in one row
but I hate scrolling all the way over.

Does that help?
----------------------

Regards,

Ron
Microsoft MVP (Excel)

 

[Guest]

hi,
format >cells>alignment tab>check wrap text
Adjust column width to control wrap.

Regards
FSt1

 

[Guest]

Ruthie

after each line... While holding down "alt" hit enter.

Mike Rogers