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:
https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msowinother/data-velidation-drop-list/fa0aa7f7-64fc-4856-ae76-e299480827db
Jon Wittwer
shared this idea
8 comments
-
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!!!!
-
PerryPhrases
commented
YES! Please Do This!
-
Joe
commented
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