In Excel how do I force text into next line before first is full?

[Wentworth]

,I am using Office XPPro (PC) but although I used Word a lot before I retired
I am only now trying to do things in Excel (and incidentally Access).

I want to put the membership records of a club into an Excel spreadsheet and
to show each postal address divided (as it would be on an envelope) into
several lines, some of them short. Since, when I am typing in data, pressing
the Return key takes me to the next cell, not the next line, at present
wherever I want a line break I am having to put in enough extra spaces to
push the next word over the edge of the cell so that it wraps into the next
line. I feel there must be a simpler way and would be grateful for help in
finding it.

 

[Don Guillett]

If you mean what happens when you touch the ENTER key then
tools>options>edit>check move after enter>select down

 

[John]

Hi Wentworth
If I understand your question , you want to do a line feed in a cell.
Press and hold the 'Alt key" then the "Enter key".
HTH
John

 

[trip_to_tokyo]

Hit ALT and the enter key.

Please hit Yes if my comments have helped.

Thanks.

 

[Wentworth]

Many thanks to all for the prompt and helpful response.

 

[George Gee]

Alt + Return

George Gee

 

[cmckeever]

In Excel 2007, Alt-Enter puts a Hard Return (new line) into a cell. I don't
know about your version.

 

[Gord Dibben]

I agree with Russell

Keep each element of an address in its own cell acrosss a row.

Easier for sorting and/or filtering by address element like Name or City
etc.

Use Word as your label or envelope producer.


Gord Dibben MS Excel MVP

 

[cmckeever]

I also agree with Russell.

cmckeever

Hi

Whilst other members have answered your question you may wish to consider
the following.

From what you have said I anticipate that you would at some stage need to
mail all your members. I can see what you are trying to do but perhaps if
you were to set up your s/s so that each consecutive cell in a row has
<name<address 1st line<address 2nd line<zip/post code< or something like
that; you will then be able to do a mailmerge frpm Word rather than print
the
labels as you appear to intend.

Apologies if this is something you have already considered and dismissed.