| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to insert a soft return into a single cell
I wish to have information on two lines in one cell for certain related data
but if I hit return it goes to the next cell. Is there a way to do a soft return or have seperate lines in a single cell without dividing it into two cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to insert a soft return into a single cell
Alt+Enter should do what you want.
Mike "Jax_R" wrote: I wish to have information on two lines in one cell for certain related data but if I hit return it goes to the next cell. Is there a way to do a soft return or have seperate lines in a single cell without dividing it into two cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to insert a soft return into a single cell
also make sure you have the cell formatted for wrap text
format-cell-alignment select wrap text "Mike H" wrote: Alt+Enter should do what you want. Mike "Jax_R" wrote: I wish to have information on two lines in one cell for certain related data but if I hit return it goes to the next cell. Is there a way to do a soft return or have seperate lines in a single cell without dividing it into two cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the vale of multiple cells into a single cell | Excel Worksheet Functions | |||
| soft return | Excel Discussion (Misc queries) | |||
| How do i insert a image to a single cell then click on the cell & | Setting up and Configuration of Excel | |||
| Insert a imge to a single cell | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Linear Mode
