Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2003 validation list question?
Hi, I have a question I'm hoping someone can help. I made a validation list with over 10 items so I have a scroll through to find what I need to choose. Is there a way to expand the drop down box so it opens everything on the list so you wouldn't have to scroll down? Thanks
1 Answer
- garbo7441Lv 79 years agoFavorite Answer
Not really, as the built in default for the number of rows to display without scrolling, in a drop down menu is 8. This can be modified in userform objects, and might be accomplished with some serious API calls, but not easily in built in Excel comboboxes or data validated cells.