+ Reply to Thread
Results 1 to 6 of 6

Data Validation Drop Down Not Displaying Correctly

  1. #1
    Registered User
    Join Date
    05-14-2020
    Location
    Washington State
    MS-Off Ver
    2016
    Posts
    61

    Question Data Validation Drop Down Not Displaying Correctly

    I have attached a spread sheet where cell B3 has been designated for data validation. The data is pulled from cells AG26 thru AG28. Hopefully, as you can see, when either 8" or 12" is selected cell B3 correctly displays the data. However, when 12-1/2" is selected cell B3 appears to display the blank area between the 12" and 12-1/2" with only portions of the two values showing. Any help on this would be appreciated. I had to delete the other information on this sheet because of its proprietary nature, so I apologize in advance that it's only a single cell, but I hope this is sufficient for someone to recognize what's causing this error.

    Thanks,

    Matt
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,384

    Re: Data Validation Drop Down Not Displaying Correctly

    Seems to be displaying fine here. Can you show a screenshot of what you are seeing?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-14-2020
    Location
    Washington State
    MS-Off Ver
    2016
    Posts
    61

    Re: Data Validation Drop Down Not Displaying Correctly

    Thanks for taking a look at this Ali. I've attached a file which contains a screenshot.
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Data Validation Drop Down Not Displaying Correctly

    It seems to me that the cell is not wide enough to display 12 1/2" in a single line and not tall enough to display 12 in the first line and 1/2" in the second.
    As the font is Arial 9 the width of column B could be set at 6 to display in one line or the height of row 3 could be set to 24.75 (33 pixels) so that word wrap can display in two lines.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    05-14-2020
    Location
    Washington State
    MS-Off Ver
    2016
    Posts
    61

    Re: Data Validation Drop Down Not Displaying Correctly

    Thanks JeteMc,

    I did try lengthening the cell, but evidently didn't try widening it. I feel somewhat foolish that it was as simple as that. Thanks for your help.

    Matt

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Data Validation Drop Down Not Displaying Correctly

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. [SOLVED] Displaying dashboard information with validation drop down list
    By HelloMrAnderson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2015, 03:19 PM
  2. displaying list based on data selection in drop down of data validation
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2014, 12:51 AM
  3. Pivot table not displaying data correctly
    By Klipvis in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-23-2014, 06:24 AM
  4. [SOLVED] Data validation lists not working correctly
    By afrabat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2014, 07:10 PM
  5. [SOLVED] Data Bars in Conditional Format are not displaying % from 0-100 correctly in the cell
    By maldoncn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 02:17 AM
  6. Monthly data not displaying correctly on chart
    By Redder Lurtz in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-18-2013, 11:29 AM
  7. Replies: 1
    Last Post: 08-18-2009, 07:35 AM

Tags for this Thread

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