Change font size of dropdown list

[loroll1991]

Hello,

I have created a dropdown list in my excel spreadsheet.

The font of the dropdown list is unreadable. Please can you confirm how I would increase the font size? Increasing the font size of the cell does not work.

The dropdown list (Monday - shown below) is generated using Data Validation and using Column1 (right hand side) to get the info.

Thanks,

Laura.

 

[KOKOSEK]

Font in drop down list created by Data validation, imho, can't be changed.

 

[Eric W]

Right, you can't change the font size in Data Validation drop down list. It's a definite pain. 2 options. You can increase the Zoom on the sheet, but of course that increases everything else too. You can then shrink font sizes and column widths etc. everywhere else to perhaps get something that works for you, but that's a bit of a kludge. The other option is to insert an ActiveX Combobox, which allows you to change the font size.