Results 1 to 2 of 2

Drop-down list Feature Inquiries

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2019
    Location
    USA
    MS-Off Ver
    Windows 365
    Posts
    3

    Drop-down list Feature Inquiries

    1.) If I have 15 items in a list (Data Validation), the drop-down window itself is only long enough to show 5 or so items and so, using my mouse, I have to click and drag the scroll bar to scroll down the list. I can't even using my mouse scroll wheel. Its almost counter productive and defeats the purpose of convenience for my needs. Is there any way to increase the size of the drop down window to display the whole list, or at least more of the list? I am not asking about font sizes, nor am I asking about how to expand the source items included for the list.

    2.) Is there a way to make it where the cell with the drop-down list will predict and auto populate information As you're typing in that cell?
    W. . .
    We. . . Fills in with "Wedding" since "Wedding" is the only item in the list that matches "W" or "We"

    I feel like this should be very possible since, by default, a work sheet will predict and auto populate information as you're typing in a cell, if matching information has already been entered within the column you're typing in. I just can't seem to figure it out.

    Your time and Any feedback regarding any of this will be deeply appreciated!
    Last edited by varxtis; 03-13-2020 at 05:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-05-2015, 12:45 AM
  2. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  3. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  4. Drop Down List (Data Validation) Need to start at current value in list
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 11:14 AM
  5. Data validation List: A macro to initiate drop down list?
    By dchubbock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2013, 08:12 PM
  6. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  7. Replies: 1
    Last Post: 07-08-2005, 11:05 AM

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