Dropdown box fonts RRS feed

  • Question

  • Hi all,

       I got Win7 and Excel 2010.  I have a workbook that was previously zoomed to 75%, In one worksheet I have a few data validation dropdowns, where the values are from another worksheet, but then when viewing the values on a dropdown, the fonts became really small.  I zoom the worksheet to 85% and the drop down values became bigger and more legible.  

       Since the worksheet has a lot of information, I do need to keep it zoom to between 75% to 80%.  My question is, is there a way to make the dropdown values fonts bigger despite the worksheet's view is reduced?  Meaning, can I forced the fonts in the dropdown values to appear bigger to allow users to select the values much more easily?

    Thanks in advance,


    Wednesday, January 28, 2015 4:33 PM


All replies