Drop down lists

New Contributor

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?

4 Replies

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 ball

As 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:

Scroll up and down using the mouse scroll wheel.gif

 

 

Hope that helps

@Haytham Amairah this really doesn't work very well at all. Whenever the grey bar (position indicator on the right side) reaches your mouse pointer, the scrolling doesn't work anymore and you have to move you mouse pointer again. Besides that it's really not intuitive at all. Excel has come such a long way, this should be a non-issue in 2022. It should just scroll like literally every other drop-down in any software ever