Wrapping text in a Drop Down List
 

Does anyone know how to wrap text if it's too long so it would fit in a drop
down box. I have been going crazy trying to figure this out. My list is
already wrapped in the cell but when I pick it for a drop down list, it does
not show it wrapped, but instead straight on one line so I can't see all the
information. Please help me.

Wrapping text in a Drop Down List
 

Is this a Data Validation dropdown list?

If so, can't be done.

You could make the column wider.


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 09:19:02 -0700, Lisa wrote:


Does anyone know how to wrap text if it's too long so it would fit in a drop
down box. I have been going crazy trying to figure this out. My list is
already wrapped in the cell but when I pick it for a drop down list, it does
not show it wrapped, but instead straight on one line so I can't see all the
information. Please help me.