Tags: drop-down, excel, font, function, increase, menu, menus, microsoft, msdn, size, software, text, users, validation

How to change the font size of Data Validation in drop-down menu?

On Microsoft » Microsoft Excel

1,659 words with 2 Comments; publish: Fri, 23 May 2008 04:00:00 GMT; (30678.13, « »)

I need to increase the font size for my text menus that I have made with Data

Validation function. How can I do that, as the users can not read such small

font?

Thanks,

Dori

All Comments

Leave a comment...

  • 2 Comments
    • Hi Dori,

      The font size in a data validation list cannot be changed but see Debra

      Dalgleish's suggested workaround at:

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

      Regards,

      Norman

      "DORI" <DORI.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:47EFF796-48CA-4C24-AA12-483657024426.excel.questionfor.info.microsoft.com...

      >I need to increase the font size for my text menus that I have made with

      >Data

      > Validation function. How can I do that, as the users can not read such

      > small

      > font?

      > Thanks,

      > Dori

      #1; Fri, 23 May 2008 04:02:00 GMT
    • Thanks for the web address.

      Dori

      "Norman Jones" wrote:

      > Hi Dori,

      > The font size in a data validation list cannot be changed but see Debra

      > Dalgleish's suggested workaround at:

      > http://www.contextures.com/xlDataVal08.html#Font

      >

      > --

      > Regards,

      > Norman

      >

      > "DORI" <DORI.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > news:47EFF796-48CA-4C24-AA12-483657024426.excel.questionfor.info.microsoft.com...

      > >I need to increase the font size for my text menus that I have made with

      > >Data

      > > Validation function. How can I do that, as the users can not read such

      > > small

      > > font?

      > > Thanks,

      > > Dori

      >

      >

      #2; Fri, 23 May 2008 04:03:00 GMT