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

117 votes

Jon Wittwer shared this idea · May 16, 2017 · Flag idea as inappropriate… · Admin →

17 comments

An error occurred while saving the comment

KellyK commented · January 13, 2021 11:01 · Flag as inappropriate

Please add an option to increase font size for data validation drop downs

Submitting...
Anonymous commented · December 18, 2020 00:44 · Flag as inappropriate

Please give the option to increase the text in a drop down box.

Submitting...
Anonymous commented · November 17, 2020 09:46 · Flag as inappropriate

I can't see the choices! This should have been fixed many years ago.

Submitting...
Anonymous commented · October 12, 2020 01:02 · Flag as inappropriate

Such a useful function but who can see the list?

Submitting...
Anonymous commented · September 24, 2020 05:38 · Flag as inappropriate

Yes, I'd like this.

Submitting...
Anonymous commented · September 20, 2020 10:01 · Flag as inappropriate

Here Here! Please Fix!!!!!!!

Submitting...
Lukas commented · September 08, 2020 06:52 · Flag as inappropriate

How can this still be a problem in 2020?

Submitting...
Anonymous commented · September 04, 2020 12:25 · Flag as inappropriate

Unhook the list box font size from the zoom setting. How hard can that be?

Submitting...
Anonymous commented · September 01, 2020 08:37 · Flag as inappropriate

Years have passed and this still lingers - Shame on you!! Bill Gates. Your customers aren't important?!!!

Submitting...
Ross Fontana commented · May 15, 2020 05:20 · Flag as inappropriate

Have a function like comments or just add an edit font tab in the validation window.

Submitting...
James Goodhew commented · February 27, 2020 06:19 · Flag as inappropriate

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!).

Submitting...
Kimberly J Walker commented · October 03, 2019 08:31 · Flag as inappropriate

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!!!!

Submitting...
PerryPhrases commented · April 05, 2019 08:52 · Flag as inappropriate

YES! Please Do This!

Submitting...
Joe commented · October 08, 2018 08:23 · Flag as inappropriate

Agreed would be extremely helpful.

Submitting...
Josh Blackman commented · August 06, 2017 13:12 · Flag as inappropriate

Please do this one, its huge

Submitting...
Katsumi Blisk commented · June 02, 2017 14:09 · Flag as inappropriate

Very difficult to accurately select on touch screens

Submitting...
Steve Fell commented · May 16, 2017 20:58 · Flag as inappropriate

seems like such a small thing but would be so helpful as I to have had this issue on a few sheets

Submitting...