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? |
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? |
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