ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Mulitple text lines in a single cell (https://www.excelbanter.com/new-users-excel/223421-mulitple-text-lines-single-cell.html)

Mrs.Aguire

Mulitple text lines in a single cell
 
I need to type several sentences into one single cell but I can not for the
life of me figure out how to get it to make mulitple text lines in one
cell...

It looks like this........

and I need
it to look
like this.

Please please help!

Sheeloo[_3_]

Mulitple text lines in a single cell
 
After typing each line press ALT-ENTER instead of ENTER to go to the next
line in the same cell.
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"Mrs.Aguire" wrote:

I need to type several sentences into one single cell but I can not for the
life of me figure out how to get it to make mulitple text lines in one
cell...

It looks like this........

and I need
it to look
like this.

Please please help!


Dave

Mulitple text lines in a single cell
 
Hi,
Right click on the cell you want, then choose Format cells. Choose the
Alignment tab, then tick the Wrap text tick box.
This will give you multiple lines in your cell, but you won't have much
control over where each line starts and finishes. To control this, when you
type some text, then want to start a new line within the same cell, press
Alt+Enter.
Hope this helps.
Regards - Dave.


All times are GMT +1. The time now is 01:52 PM.

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