+ Reply to Thread
Results 1 to 3 of 3

How to expand a drop down list .

  1. #1
    Forum Contributor
    Join Date
    08-25-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    125

    How to expand a drop down list .

    Hi Everyone

    Could someone please point me in the right direction.
    I have a data validation list that has approx 40 items.
    When I select the cell with the drop down list - only 10 or so items appear . I then have to use the scroll bar on the side to look further in the list.
    Is there a way that more than 10 or so ( possibly all ) items appear in the drop down box when the cell is selected - or is there a way that one can scroll down using the mouse wheel. ( I have to use the scroll bar at the moment ).

    Please help

    Thanks

    Onesock

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to expand a drop down list .

    Not sure if that can be done.

    Why not try using the keyboard arrow keys or the PgUp and PgDown keys instead of the mouse
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    08-25-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: How to expand a drop down list .

    Hi Ace_XL

    Thanks for the response.
    I have tried the arrow up and down keys.
    Works great , but a bit uncomfortable , being on the right side of the keyboard and using my left hand to push those buttons.(not lazy , just trying to be more efficient). Mouse scroll would be ideal , but If it cant be done , so be it.

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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