+ Reply to Thread
Results 1 to 2 of 2

Font Size in Drop Down Boxes

  1. #1
    Registered User
    Join Date
    09-30-2014
    Location
    Columbus, Ohio
    MS-Off Ver
    2010
    Posts
    9

    Font Size in Drop Down Boxes

    How does one adjust the font size in drop down boxes?

    I have created drop down boxes in the past and have never had trouble reading them or using them, but on a worksheet I am currently creating in Excel 2016 the data in the dropdown box is so small it can't be read...

    Drop Down Selection Image.JPG

    Can that type size be adjusted?

    Thanks,
    Paul

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Font Size in Drop Down Boxes

    I assume you are using Data Validation with a dropdown list. It looks like you have your view zoomed out, which shrinks the font size of a dropdown list.

    There is no way to directly adjust the font. There are two strategies:

    1. Reduce the size of the fonts on your sheet, and zoom back in
    2. Use a ComboBox instead of data validation

    I can give more details for either if you attach your file.

    The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-29-2015, 01:25 PM
  2. Changing box and font size in form control check boxes?
    By Hambone70 in forum Excel General
    Replies: 3
    Last Post: 08-13-2014, 10:16 AM
  3. Default Font size in comment boxes ?
    By conks in forum Excel General
    Replies: 2
    Last Post: 08-27-2008, 08:29 AM
  4. [SOLVED] Drop Down Box Font Size
    By GarToms in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 08:55 AM
  5. [SOLVED] Need feature to change font size default in COMMENT boxes.
    By GED01 in forum Excel General
    Replies: 1
    Last Post: 04-03-2006, 09:25 AM
  6. [SOLVED] Drop down box font size
    By Francis Hookham in forum Excel General
    Replies: 2
    Last Post: 12-17-2005, 06:25 AM
  7. Replies: 1
    Last Post: 10-28-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1