Resizing Data Translation Drop Down

StevenPMoffat used Ask the Experts™
I have a drop down in a cell that is a list using a Range Name.  
I want the viewing area of the list to be longer (higher).   Is there a way to change this?  It appears to be eight lines by default.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

unfortunately, you can't change the data validation dropdown list, neither font size nor rows displayed.

See here for a few ideas for working with data validation:

cheers, teylyn


Thanks for the URL pointer.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial