Forum Discussion

sk1325's avatar
sk1325
Copper Contributor
Feb 24, 2019

Drop down lists

1) can there be an option to scroll down the list with the mouse instead of the arrow up and down?   2) can there be a search option by ABC or Numbers instead of scrolling?
excel
TheConsultant's avatar
TheConsultant
Copper Contributor
Apr 04, 2023
This feature works now. An update must have recently dropped that allows my worksheets with data validation lists to scroll regardless of where your mouse cursor is located within the list element.
Max_W13's avatar
Max_W13
Copper Contributor
Apr 04, 2023

TheConsultant hm, interesting that this seems to work for you. I've updated MSO 365 today again, and it is still only scrolling in drop-down menus when the mouse-pointer is hovered over white-space in the scroll-bar on the right. Scrolling does not work when the mouse pointer is either not on the scrollbar nor if the cursor is hovering over the grey-bar itself. 

What is your release number where this works for you?

My current release is: Version 2302 (Build 16130.20332), Current Channel.

  • TheConsultant's avatar
    TheConsultant
    Copper Contributor
    Apr 30, 2023
    From the looks of it (based on your reply, and of the most recent replies) it must have been a temp roll-out. It has even reverted for me as I can no longer scroll when I'm not hovering over the scroll bar.
    My release is: Version 2303 (Build 16227.20280), Current Channel.
  • lylemock's avatar
    lylemock
    Copper Contributor
    Apr 18, 2023

    I'm having the same problem, crazy thing it worked for few weeks then opened up the same document several people share and now it doesn't work. Can still scroll by hitting the arrows and hovering over the scroll bar but can not utilize the scroll wheel on mouse anywhere. for past few weeks it has been great. when you click the drop down it actually opens the list larger font and allows scroll wheel anywhere etc. makes our quote sheet we use almost every day more user friendly. Max_W13 

    • Jan_Van_Rafelghem's avatar
      Jan_Van_Rafelghem
      Copper Contributor
      May 04, 2023

      Almost started thinking I was losing my mind. It happened to me as well. It worked for a few days or weeks and then suddenly didn't anymore. Possibly after an update. Have you been able to resolve this? lylemock 

      • EsHarito's avatar
        EsHarito
        Copper Contributor
        Jul 15, 2023
        As of 7/15/2023 Scrolling and Autocomplete is working on droplist. The only thing remaining here is for multiples selection Items on the same droplist, autocomplete stop working after first selection. Wish this could be updated.
    • APReal's avatar
      APReal
      Copper Contributor
      Apr 26, 2023

      lylemock same problem here. One day it was just working beautifully, the drop down would open large enough to see the whole selection and scrolled with the mouse. Now, all of the sudden, it has reverted back to only showing part of the selection and not scrolling. Wish they would have kept it the way it was last week.

Resources