Typing an address into spreadsheet

[Cheryl]

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.

 

[Kevin B]

Press <Alt> + <Enter> to add a new line in the cell.

 

[Cheryl]

Kevin, I just tried that and nothing....any other suggestions?? I really
appreciate the help

 

[Steven]

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'

 

[Jacinthe]

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.

 

[Jacinthe]

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.

 

[Rob L]

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