View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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?