Increase the Data Validation List Items Font Size
The font size of the list items within a Data Validation list is often too small to read. If you can't add a feature to allow the user to choose the font size of the list, then perhaps you could do one of the following:
1) Set the font type (Arial, Calibri, etc.) and size equal to the size of the Normal font
2) Set the font type and size equal to the font size of the Cell
See the related post in the Excel answers forum:
Ross Fontana commented
Have a function like comments or just add an edit font tab in the validation window.
James Goodhew commented
Totally agree with below posters. I'm aware we can do it using ActiveX controls instead, but that invalidates the selection for all Mac users - something which as a business offering products we simply can't tolerate.
Also window size (8 items max is too small!).
Kimberly J Walker commented
been searching for an answer to how to do this for a few hours...now i know why i did not find anything...it's because you can't!!! FIX THIS!!!!
YES! Please Do This!
Agreed would be extremely helpful.
Josh Blackman commented
Please do this one, its huge
Katsumi Blisk commented
Very difficult to accurately select on touch screens
Steve Fell commented
seems like such a small thing but would be so helpful as I to have had this issue on a few sheets