+ Reply to Thread
Results 1 to 4 of 4

Data Validation list has very small font

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Data Validation list has very small font

    Hi, I have an excell workbook with some data validation list. When I click to cell to make the selection from my list, the list with extremely tiny. I can make it better by changing the zoom on my whole work book, but then i can't see all i need to. is there a way to just make my font on the data validation list bigger and readable?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Data Validation list has very small font

    OK, I've played with this a bit and have found no way to do it. If it can be done I suspect you'll need a VBA / macro solution.

    With that thought in mind and with this being your only response here, so far, you might want to consider reposting in the VBA section of the Forum.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Data Validation list has very small font

    I think you are correct there, Flame, I think the only way round this is with VBA.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Data Validation list has very small font

    Quote Originally Posted by FDibbins View Post
    I think you are correct there, Flame, I think the only way round this is with VBA.
    Thanks for the confirmation. I wasn't really sure.

+ 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. Font Size of data validation List
    By mahju in forum Excel General
    Replies: 2
    Last Post: 03-29-2011, 12:13 PM
  2. change font for validation data list
    By eugz in forum Excel General
    Replies: 3
    Last Post: 10-07-2008, 08:01 AM
  3. Font is small in Data Validation
    By aposatsk in forum Excel General
    Replies: 0
    Last Post: 08-23-2006, 01:05 PM
  4. [SOLVED] How can the font in the Data Validation list be changed?
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2006, 11:00 PM
  5. [SOLVED] data validation list drop down text format too small
    By Bruce Edwards in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2005, 03:06 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