2

Sometimes in my filter views, whenever I have really small columns, the triangle icon to filter them does not show up at all. I'm able to temporarily resolve this by expanding the column, but it's really annoying to have to do this every time I want to filter by that column. Is there another way to filter the column without that temporary solution?

EDIT: I'm on a MacBook.

Improve this question
0

1 Answer 1

Reset to default
1

If you are not able to see filter triangle like in B1, select it by clicking on B1 and then simply press:

  • Windows: CTRL + LEFT ALT + R

  • Mac: CTRL + ⌘ + R

    0

Improve this answer
5
  • I tried both Ctrl + Left Alt + R and Cmd + Left Alt + R, and neither one worked.
    – ZeuxWarrior
    Apr 22, 2019 at 23:12
  • I'm using Google Chrome.
    – ZeuxWarrior
    Apr 22, 2019 at 23:17
  • ctrl+leftalt+r is called Open drop-down menu on filtered cell - support.google.com/docs/answer/… and it works with both filters (green & black)
    – user0
    Apr 22, 2019 at 23:23
  • also when pressing ctrl+leftalt+r you need to be in that cell where is that triangle otherwise it won't work. referencing the image from the posted answer - it would work only if A1 or B1 is highlighted/selected.
    – user0
    Apr 22, 2019 at 23:26
  • 1
    It's Ctrl + ⌘ + R on Mac. I got it to show up now. Thank you.
    – ZeuxWarrior
    Apr 22, 2019 at 23:38

Your Answer

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

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