If you need to display your address in this manner in a drop down you may
have to wrap text in cell
right click -- format cell -- alignment -- wrap text
--
grizz


"JustAnOilMan" wrote:

Thanks for any help in advance!
I would like to have a 4 line billing address dropdown list of multiple
companies as follows.
ABC Company
1234-9th st
Anywhere USA
77689
Is it possible to do this in Excel 2003? The dropdown can contain the whole
address or just the company name but I want to display the address as above
in 4 separate rows.