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

  • Thread starter Thread starter Wentworth
  • Start date Start date
W

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.
 
If you mean what happens when you touch the ENTER key then
tools>options>edit>check move after enter>select down
 
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
 
In Excel 2007, Alt-Enter puts a Hard Return (new line) into a cell. I don't
know about your version.
 
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
 
I also agree with Russell.

cmckeever
Russell Dawson said:
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.
Click to expand...
 
Back
Top