View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Showing full pull-down list

Not if you are using datavalidation


--
Regards,

Peo Sjoblom



"DianeMcP" wrote in message
...
I have an excel spreadsheet where there is a list of "categories"
(currently
only 10 entries, but can grow), and I would like all 10 entries to show in
the pull-down list. It's only showing 8.

There must be a setting somewhere where I can tell Excel to show complete
list or increase the number showing.... isn't there?
--
Thanks,
Diane