View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Hill Mr. Hill is offline
external usenet poster
 
Posts: 1
Default The drop down menu of my validation list needs to display more.

When you use the Data menu's validation category, threre is an option to only
allow a cell to hold a values from a LIST. After you create a list there
suddenly appears a little arrow (or upside down triangle) next to the cell
you validated. When you click on this arrow some of the values in your list
are displayed.
My problem is that the list only displays 8 values; I need it to display 10.
How do I make the drop down menu of my validation list display more values??