data velidation drop list

the issue I have is, I have a data validation list on my spread sheet, when you click on it to select from the list the font is so small that you can hardly read it, most of the time I just hold ctrl and scroll my mouse to make the whole page bigger then select form the list and then return the sheet to its original size. my question is, can you change the font size of the list. regards Steve


The straight forward answer to your question is NO - you cannot change the font size of the list inside a drop down.

However, for your knowledge, this font size is directly related with the zoom size of the window of that particular excel worksheet (inside which the drop down is placed).

Increase the zoom size and the font size will automatically increase too.

Hope this Helps.

Excel is Awesome!! One problem always has multiple solutions.
If my answer solves your problem, please tick mark it as Answered.
Cheers RajeshC

11 people found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated April 27, 2021 Views 6,059 Applies to: