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 were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated August 1, 2020 Views 5,217 Applies to: