Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to split wrapped text in a single cell into multiple lines | Excel Discussion (Misc queries) | |||
Need to add 2 or more lines of data into a single cell in Excel | Excel Discussion (Misc queries) | |||
Mulitple Windows in Single Workspace | Excel Discussion (Misc queries) | |||
two lines of text in a single row? | Excel Discussion (Misc queries) | |||
two lines of text in single row | Excel Discussion (Misc queries) |