Resizing Data Translation Drop Down

StevenPMoffat
StevenPMoffat used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

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

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: http://www.contextures.com/xlDataVal08.html

cheers, teylyn

Author

Commented:
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