View Single Post
  #4   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
...
Sorry T. Valko, When I pull up your response the screen is blank. Can you
please try again???

"Banker" wrote:

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.