Is there a way to expand (or shrink) the in-cell dropdown when using data validation. Right now, the dropdown list is only showing 8 items in the dropdown list. I want to expand the size to show all entries, which is 20. Thanks in advance for any comments.
Bookmarks