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

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

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