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

17 comments
-
KellyK commented
Please add an option to increase font size for data validation drop downs
-
Anonymous commented
Please give the option to increase the text in a drop down box.
-
Anonymous commented
I can't see the choices! This should have been fixed many years ago.
-
Anonymous commented
Such a useful function but who can see the list?
-
Anonymous commented
Yes, I'd like this.
-
Anonymous commented
Here Here! Please Fix!!!!!!!
-
Lukas commented
How can this still be a problem in 2020?
-
Anonymous commented
Unhook the list box font size from the zoom setting. How hard can that be?
-
Anonymous commented
Years have passed and this still lingers - Shame on you!! Bill Gates. Your customers aren't important?!!!
-
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