Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 328
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the text colour in a drop down list? Bluetone101 Excel Discussion (Misc queries) 1 October 29th 07 03:41 PM
Text & symbols in the same drop-down list Rachael F Excel Discussion (Misc queries) 0 June 8th 06 12:48 PM
How can I wrap text in a drop down list? wrapped Excel Worksheet Functions 0 January 25th 06 05:53 PM
Text size in validation drop-down list box Jon Excel Worksheet Functions 1 October 11th 05 08:20 PM
Colour of the Text in a drop box list I have ... RobShep Excel Discussion (Misc queries) 7 February 27th 05 04:29 AM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"