PDA

View Full Version : Forcing text onto new line in cell


Doug Poll
December 3rd 04, 12:59 PM
Hi,
Sorry if this is obvious, but I can't see a way of forcing text onto a new
line in a cell in Excel 2002, as one would get with say a carriage return in
word. I know I can wrap text and this is set on, but for neatness I would
like to show text entry more as a list within a cell (I can't use more than
one cell in this instance). I can acheive the result by continous pressing
of the space bar until the wrapping kicks in, but this seems an unlikely
prefered method.
regards
Doug

Vikrant Vaidya
December 3rd 04, 01:09 PM
press alt+enter wherever you want to change line. Just like you press enter
in word.

"Doug Poll" wrote:

> Hi,
> Sorry if this is obvious, but I can't see a way of forcing text onto a new
> line in a cell in Excel 2002, as one would get with say a carriage return in
> word. I know I can wrap text and this is set on, but for neatness I would
> like to show text entry more as a list within a cell (I can't use more than
> one cell in this instance). I can acheive the result by continous pressing
> of the space bar until the wrapping kicks in, but this seems an unlikely
> prefered method.
> regards
> Doug

Frank Kabel
December 3rd 04, 01:09 PM
Hi
ALT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"Doug Poll" <Doug > schrieb im
Newsbeitrag ...
> Hi,
> Sorry if this is obvious, but I can't see a way of forcing text onto
a new
> line in a cell in Excel 2002, as one would get with say a carriage
return in
> word. I know I can wrap text and this is set on, but for neatness I
would
> like to show text entry more as a list within a cell (I can't use
more than
> one cell in this instance). I can acheive the result by continous
pressing
> of the space bar until the wrapping kicks in, but this seems an
unlikely
> prefered method.
> regards
> Doug

Google