From long dropdown to a short one

[XLFanatico]

I used to have a longer list of dropdown in the cell name(top left of
worsheet) including names given by me to ranges. I had to reinstall XL and
now I do not
get more than 7 items unless I scroll down.
Is there a setting to change it back to show all names when clicked?
Thanks.

 

[Jacob Skaria]

Refer the below link

http://www.contextures.com/xlDataVal11.html

If this post helps click Yes