Excel - autofilter: filter box

[onedtent]

Hi,

When a user clicks on a drop down arrow to filter a list, the resulting box "drops up" rather than down. So, selections such as All, Top 10, Custom etc are off the screen.

Pls help

 

[Rdesacola]

The reason why the list "drops up" rather then down is because of insufficient room to display the dropdown list towards the bottom of the screen. You could try scrolling the whole sheet down so that you have enough room to display the list downwards ... or even if the list displays up... the user should have a scroll bar on the right side of the list after clicking on the dropdown arrow to scroll upwards and display the "ALL, TOP TEN, ETC..." You may also need to unfreeze the screen or choose a different freeze point in order to allow the list to drop down rather than up.

Hope this helps...
RD