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.

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.

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.

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.

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.

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.

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.