Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you start a new line within a cell?
I think this is a very basic question, but how do you start a new line
(or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
#2
|
|||
|
|||
hi,
data in a cell is stored as a continuous string. there is no "new line" per say. but you can wrap the text. formatcellsalignment tab check wrap text. this way the text in the cell will seem to be on different lines. regards FSt1 " wrote: I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
#3
|
|||
|
|||
Use ALT-ENTER rather than ENTER
-- Gary's Student " wrote: I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
#4
|
|||
|
|||
Use Alt-Enter
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
#5
|
|||
|
|||
use alt and enter or either go to cell formatting and select work wrap |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I enter more than one line in the same Excel Cell by using. | Excel Discussion (Misc queries) | |||
make line in chart start at y axis | Charts and Charting in Excel | |||
How can I strip a new line /nl in a cell in Excel globally | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Line styles for Cell Borders | Excel Discussion (Misc queries) |