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

,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
toolsoptionseditcheck move after enterselect down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wentworth" wrote in message
...
,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.

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
"Wentworth" wrote in message
...
,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.

Hit ALT and the enter key.

Please hit Yes if my comments have helped.

Thanks.

"Wentworth" wrote:

,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.

Many thanks to all for the prompt and helpful response.

"John" wrote:

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
"Wentworth" wrote in message
...
,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.

.

Alt + Return

George Gee


"Wentworth" wrote in message
...
,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.

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


"Wentworth" wrote in message
...
,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.

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
nameaddress 1st lineaddress 2nd linezip/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.


--
Russell Dawson
Excel student


"Wentworth" wrote:

,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.

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

On Sun, 7 Feb 2010 09:19:01 -0800, Russell Dawson
wrote:

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
nameaddress 1st lineaddress 2nd linezip/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.

I also agree with Russell.

cmckeever
"Russell Dawson" wrote in message
...
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
nameaddress 1st lineaddress 2nd linezip/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.


--
Russell Dawson
Excel student


"Wentworth" wrote:

,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.