Forum Discussion

Micheal Herrin's avatar
Micheal Herrin
Copper Contributor
Jun 28, 2018

Excel drop-down list text

does anyone know why my text in my drop-down list is to small to read.

 

is there a way to increase the size of the text.

 

the over all length of the text is smaller the the cell I am working in.

excel

3 Replies

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jun 28, 2018

    Can you provide a screenshot of your drop down so the community can see what type of dropdown you're using.

     

    I've seen this behavior with ActiveX controls in the past.  You pretty much have to keep the zoom at 100% in order to ensure the information is readable....

      • Rusty Dane's avatar
        Rusty Dane
        Brass Contributor
        Oct 12, 2018

        Not in Data Validation.  Here's some options.

        https://www.mrexcel.com/forum/excel-questions/130243-data-validation-list-font-too-small.html

         

        https://www.contextures.com/xlDataVal08.html#Font

Resources