Forum Discussion
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?
- 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.
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.
- 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.
Hi,
You can scroll a dropdown list up and down using the mouse scroll wheel.
But to be able to use this option, you have to hover the mouse over the scroll bar instead of the list items.
With regards to the second question, there is no option at this time.
So I suggest you post an idea in Excel's Suggestion Box asking the Excel team to add such a feature.
Regards,
Haytham
- thanks for your response.
i meant scroll down with the mouse ballAs I said in the previous reply, you can scroll a dropdown list up and down using the mouse scroll wheel.
But you have to hover the mouse over the scroll bar instead of the list items as follows:
Hope that helps
