+ Reply to Thread
Results 1 to 3 of 3

Possible to make a drop down list show options that are longer than one line?

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    Western Hemisphere
    MS-Off Ver
    2013
    Posts
    13

    Possible to make a drop down list show options that are longer than one line?

    Hello,

    After my first post was successfully answered on here in an extremely short period of time, I'm back with another one. This time, I am creating a sheet in which users will choose a relevant options from a drop down list, but some of the options are lengthier and it appears as if the drop down list does not allow word wrap. As a result, some choices are not fully shown and I am afraid this will result in poor results and inaccurate data collection. How can I make the drop down list give an extra line or two when the choice does not fit into one line? I don't want to expand the width of the cell, since it will mess up other formatting.

    Thanks!

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Possible to make a drop down list show options that are longer than one line?

    short answer
    not really

    here are some alternatives but it seems like some of these wont work for you either
    http://www.contextures.on.ca/xlDataVal08.html#Wider

    nevertheless have a look see which one may work as there are a few
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  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,929

    Re: Possible to make a drop down list show options that are longer than one line?

    Have you considered jut making that line higher?
    If it has to expand anyway - for some selections, make it that high anyway, then you can be sure other fomatting is not messed with
    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

+ 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. How to make drop down list (data validation) become longer by using any vba?
    By kikilala in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 03:08 PM
  2. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  3. Replies: 3
    Last Post: 05-30-2012, 12:35 PM
  4. Make a Drop Down List Longer
    By Zwoodman in forum Excel General
    Replies: 1
    Last Post: 11-14-2007, 01:00 PM
  5. Pivot table drop down list with data no longer valid?
    By John_Mtl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2007, 11:01 AM
  6. [SOLVED] My Excel drop-down list eliminates from list options chosen. Help
    By Sybil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 05:25 PM
  7. [SOLVED] How do I make longer a drop-down list (the window) in excel?
    By Martin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2006, 04:45 PM
  8. How do I make longer a drop-down list (the window) in excel?
    By Martin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2006, 04:15 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