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

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

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

Break the lines with Alt-Enter

--
HTH

Bob

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

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

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

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)



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

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

hi,
format cellsalignment tabcheck wrap text
Adjust column width to control wrap.

Regards
FSt1

"Ruthie" wrote:

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

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

Ruthie

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

Mike Rogers
--
The only dumb question is the one you did not ask.


"Ruthie" wrote:

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