+ Reply to Thread
Results 1 to 4 of 4

How do I change the font size in an EXCEL drop down-list?

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    How do I change the font size in an EXCEL drop down-list?

    As title describes.

    Any way to make that drop-down list appear larger? Without having to zoom all the way to 100.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How do I change the font size in an EXCEL drop down-list?

    100% is the normal size. If you are using a smaller size like 70% and compensating by using a larger font size you are causing problems for yourself.

    If you are using something other than Data Validation for the drop down list, ActiveX or Form Controls, there is sizing available in the properties of that type of drop down list.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: How do I change the font size in an EXCEL drop down-list?

    I don't think there is a way, but if you use a combo box, you can do something similar by using the properties ...

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How do I change the font size in an EXCEL drop down-list?

    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Drop down list font size
    By Quagga in forum Excel General
    Replies: 1
    Last Post: 01-31-2014, 05:25 PM
  2. Replies: 2
    Last Post: 07-02-2009, 02:43 PM
  3. change font size of drop down list
    By robert111 in forum Excel General
    Replies: 1
    Last Post: 12-08-2006, 12:24 PM
  4. Data Validation in Excel - drop down list font size
    By Mikeytj in forum Excel General
    Replies: 3
    Last Post: 03-09-2006, 04:40 PM
  5. [SOLVED] Can we change font size of values in validation drop down list?
    By linda in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 04:15 PM
  6. [SOLVED] How do I increase font size in a drop-down list in Excel?
    By hdaniels_uwco in forum Excel General
    Replies: 1
    Last Post: 10-11-2005, 01:05 PM
  7. [SOLVED] font size in a drop down list
    By kennedy in forum Excel General
    Replies: 1
    Last Post: 06-29-2005, 07: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