It's not in the official docs, but is there by any chance a non-documented/hacky keyboard shortcut for the little green filter funnel which has to be clicked to bring the "filter by" menu? Or else I am going to permanently damage my wrist soon by mouse-clicking that one icon hundreds of times (all the rest I do via keyboard!).

enter image description here

enter image description here

1 Answer 1


On window the shortcut

ALT + D then F

toggles the filter of the selected cell on and off.

To open drop-down menu on filtered cell:

Ctrl + Alt then R

  • Ctrl+Alt+R does not work for me when the filter is currently applied on the column, ie, while the funnel is solid green. It only works when filter is not applied and the funnel is not solid green.
    – spcsLrg
    Commented Jun 26, 2022 at 12:11
  • OK, I've got Ctrl+Alt+R working (sort of). The trick is to select the topmost cell (when solid green funnel), then unselect it by going down and then back on it again, then press CA+R. It just won't do it first time for some reason for me. I am now marking this as a solution. (Also, Ct+Alt+R is documented too.) Thanks!
    – spcsLrg
    Commented Jun 27, 2022 at 11:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.