Hi,

I am trying to put together a mailing list. I've created a table and want
to place customer addresses in corresponding cells. When I enter their
addresses and hit the Enter key, the different lines of the address don't
automatically shift to the next line. How do I do that so that the addresses
print out in a nice way, such as

Joe Smith
76 Main St.
Chicago, IL 47382

Thanks for any help!

I have a PC.

Caroline

"Putting an Address in a Cell" <Putting an Address in a
wrote in message
...
Hi,

I am trying to put together a mailing list. I've created a table and want
to place customer addresses in corresponding cells. When I enter their
addresses and hit the Enter key, the different lines of the address don't
automatically shift to the next line. How do I do that so that the
addresses
print out in a nice way, such as

Joe Smith
76 Main St.
Chicago, IL 47382

Thanks for any help!

I have a PC.

Caroline

I would suggest that you put the lines of the address in columns of your
Excel file, and then use Mail Merge in MS Word to print out the addresses.
http://office.microsoft.com/en-us/as...037601033.aspx
--
David Biddulph

While the long term approach is what David suggests, if all you need is a
line feed within a cell, hold Alt while pressing Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Putting an Address in a Cell" <Putting an Address in a
wrote in message
...
Hi,

I am trying to put together a mailing list. I've created a table and want
to place customer addresses in corresponding cells. When I enter their
addresses and hit the Enter key, the different lines of the address don't
automatically shift to the next line. How do I do that so that the
addresses
print out in a nice way, such as

Joe Smith
76 Main St.
Chicago, IL 47382

Thanks for any help!

I have a PC.

Caroline