| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for code to separate one line of text into multiple lines in Excel | Excel Worksheet Functions | |||
| How do I get the text to continue on the next line when its long | Excel Discussion (Misc queries) | |||
| how do I copy several lines of word text into one excel cell? | New Users to Excel | |||
| How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
| A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Linear Mode
