View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default sizing in Drop Down lists

You have to widen the column.

--
Biff
Microsoft Excel MVP


"Banker" wrote in message
...
I have attached drop down lists to a cell on my worksheet. The items in
the
list are wider than the cell that it will be viewed in. I know I can
format
the actual cell to wrap the text if it needs to for viewing after selected
but how can I VIEW the entire width needed in the drop down list when I
click
on the arrow to choose the item I wish to show?? Basically I can only
read
about half of each of the items in the list. I hope this makes sense.