Using Excel 2019, Drop Down List Is Extremly Small

markswan111

New Member
Joined
Sep 16, 2016
Messages
33
Hi guys, I have tried everything to make the font of my excel drop down list larger, the font is extremely small, I even tried changing my computer settings etc, and tried everything within excel, but no solution... I am using windows 10 and excel 2019.

anyone can help?
 
so there is no solution for a very small drop down list in excel?
Like said, if increasing the zoom of the worksheet doesn't help, I don't think there is a solution.
I don't have excel 2019 so I can't test. Probably it is a bug.
In excel 2016 increasing the zoom magnifies the DV dropdown.

If using vba is ok, how about using an ActiveX combobox instead of DV. You could use its events to dynamically resize it and to populate a different target cell .. Maybe a combobox from the forms toolbar could also work.
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,215,876
Messages
6,127,490
Members
449,385
Latest member
KMGLarson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top