Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fonts and dropdown lists (Excel 2000)

    What about the 'apparent' font size in dropdown filter list boxes?
    What you see, reasonably enough, depends on the zoom setting of the window, and it can be hard to reach a compromise.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Fonts and dropdown lists (Excel 2000)

    The apparent size is related almost wholly to the ZOOM. If you want them to appear smaller decrease the zoom, to make it larger increase the zoom

    You can then change the font size of the cell contents (format - cells) to adjust the contents to match. It is not a perfect way to do it, but it is the easiest.

    The alternative is to create your own comboboxes using the control toolbox items, which allow you control over the size, color, style, etc.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •