Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
I just began using Excel at my office don't have much knowledge of the
program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
Press <Alt + <Enter to add a new line in the cell.
-- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
Kevin, I just tried that and nothing....any other suggestions?? I really
appreciate the help "Kevin B" wrote: Press <Alt + <Enter to add a new line in the cell. -- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
Cheryl, I would actually advise against what you're trying to do.
If you assume that this database of names and addresses will be used for some time, then it makes sense for it to be updatable. People will move, people will change names. I suggest that for row 2, A2 be first name, B2 be last name, and C2 be address. Then D2 should have in it '=A2&" "&B2&" <bunch of spaces"&C2' "Cheryl" wrote: Kevin, I just tried that and nothing....any other suggestions?? I really appreciate the help "Kevin B" wrote: Press <Alt + <Enter to add a new line in the cell. -- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
Alt-Enter is the only keystroke combination I know of that does what you are
asking. What happened when you pressed it? Out of curiousity, would it not be better to break up the name and address? i.e. A4 = Name A5 = Address1 A6 = Address2 A7 = City A8 = State A9 = ZIP These addresses can still be used in mail merge or whatever, but it would be much easier to sort. "Cheryl" wrote: Kevin, I just tried that and nothing....any other suggestions?? I really appreciate the help "Kevin B" wrote: Press <Alt + <Enter to add a new line in the cell. -- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
On second thought, I would probably break up First Name and Last Name too,
like Steven suggested. Even more sortable. :) "Jacinthe" wrote: Alt-Enter is the only keystroke combination I know of that does what you are asking. What happened when you pressed it? Out of curiousity, would it not be better to break up the name and address? i.e. A4 = Name A5 = Address1 A6 = Address2 A7 = City A8 = State A9 = ZIP These addresses can still be used in mail merge or whatever, but it would be much easier to sort. "Cheryl" wrote: Kevin, I just tried that and nothing....any other suggestions?? I really appreciate the help "Kevin B" wrote: Press <Alt + <Enter to add a new line in the cell. -- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing an address into spreadsheet
Just to make the instructions completely clear.....
1. Type the name. Do NOT press enter 2. While the cursor is still at the end of the name, hold down the Alt key, and while it is held down, press enter. You "should" get a second line of text in the same cell. You can do this as often as you like (up to 256 ? characters) RobL "Cheryl" wrote in message ... Kevin, I just tried that and nothing....any other suggestions?? I really appreciate the help "Kevin B" wrote: Press <Alt + <Enter to add a new line in the cell. -- Kevin Backmann "Cheryl" wrote: I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name and address. When I type the name and hit enter to start tying the address the curser jumps from cell A3 to A4. How do I keep all the text within cell A3? I will be printing the addresses onto labels, which will be another question I'll be asking when i get to that point. LOL I need an answer ASAP. No one in my offices uses this software so I'm kinda hanging in the wind. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email address in excel spreadsheet | Excel Discussion (Misc queries) | |||
formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
Can I import a .xls spreadsheet into my wordperfect address book | Excel Worksheet Functions | |||
excel spreadsheet into address labels | Excel Worksheet Functions | |||
basic question on typing names on spreadsheet- problem | Excel Discussion (Misc queries) |