Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you get line breaks in a text cell
I've got Excel XP and there is a form I'm creating that requires some free
text input. Is there a way I can put in a line or para break into a cell (as you can in a cell of a word table). Can't easily use separate cells as the number of paras can vary. I could use word but then I lose the facility to use excel on all the cells that contain data. Any help or ideas would be appreciated. TIA Rob |
#2
|
|||
|
|||
Can you get line breaks in a text cell
Just hit Alt-Enter which editing a cell to start a new line
RFJ wrote: I've got Excel XP and there is a form I'm creating that requires some free text input. Is there a way I can put in a line or para break into a cell (as you can in a cell of a word table). Can't easily use separate cells as the number of paras can vary. I could use word but then I lose the facility to use excel on all the cells that contain data. Any help or ideas would be appreciated. TIA Rob |
#3
|
|||
|
|||
Can you get line breaks in a text cell
Just hit Alt-Enter when editing a cell to start a new line
RFJ wrote: I've got Excel XP and there is a form I'm creating that requires some free text input. Is there a way I can put in a line or para break into a cell (as you can in a cell of a word table). Can't easily use separate cells as the number of paras can vary. I could use word but then I lose the facility to use excel on all the cells that contain data. Any help or ideas would be appreciated. TIA Rob |
#4
|
|||
|
|||
Can you get line breaks in a text cell
Use your right mouse for formatting options & format the cell to wrap text.
Another idea is to use ALT & ENTER at the same time. This will allow you to create another line of text within the same cell at the point you desire. Nancy "RFJ" wrote: I've got Excel XP and there is a form I'm creating that requires some free text input. Is there a way I can put in a line or para break into a cell (as you can in a cell of a word table). Can't easily use separate cells as the number of paras can vary. I could use word but then I lose the facility to use excel on all the cells that contain data. Any help or ideas would be appreciated. TIA Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to preserve paragraph breaks in pasted text? | Excel Discussion (Misc queries) | |||
text to appear at top of cell | New Users to Excel | |||
manual line breaks | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel |