If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#3
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#4
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#5
|
|||
|
|||
In Excel how do I force text into next line before first is fu
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. . |
#6
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#7
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#8
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#9
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
#10
|
|||
|
|||
In Excel how do I force text into next line before first is full?
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. |
Thread Tools | |
Display Modes | |
|
|