ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to insert a soft return into a single cell (https://www.excelbanter.com/excel-discussion-misc-queries/145274-there-way-insert-soft-return-into-single-cell.html)

Jax_R

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?

Mike H

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?


bj

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?



All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com