Validate List - tiny font

[Oyster1967]

Hi guys,
I have created drop down lists however the selection font is sooo tiny its very difficult to read. The original list is normal size and can be seen easitly.
Could it be because there is 40 or more selections to choose from?
Any help appreciated
Cheers

Andrew

 

[GlennUK]

Do you mean the in-cell dropdown as created by doing Data Validation?

 

[Oyster1967]

Yes. When I click the drop down arrow, the selection items are very small. When selected they appear normal size. I thought it might be that I had the page on 70% zoom, but it didnt really make much difference when I expanded to 100%.

thanks

 

[Peter_SSs]

Yes. When I click the drop down arrow, the selection items are very small. When selected they appear normal size. I thought it might be that I had the page on 70% zoom, but it didnt really make much difference when I expanded to 100%.

thanks

This may help: http://www.contextures.com/xlDataVal10.html

 

[GlennUK]

Yes. When I click the drop down arrow, the selection items are very small. When selected they appear normal size. I thought it might be that I had the page on 70% zoom, but it didnt really make much difference when I expanded to 100%.

thanks

Reduce the font size in your sheet, and reduce column widths, and increase zoom. You've increased zoom from 70% to 100%. I'd recommend trying 150%, and see if that's to your liking.

 

[Oyster1967]

thanks guys, both suggestions have been very helpful

Cheers