In your source list, press Alt + Enter where you want the lines to break
Then, in the cell that contains the dropdown list, choose FormatCells
On the Alignment tab, add a check mark to Wrap Text, and click OK

In the dropdown list, you'll see a box character where the line breaks
are, but they won't appear in the cell.

Cathy Landry wrote:
Hello,

I have a drop down list that contains clinic name/address/city/st/zip/phone#
in a merged cell. Is there anyway to format the spacing so that it will look
like a proper ship-to address?

Thank you
Cathy


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html