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.

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

  • I tried both Ctrl + Left Alt + R and Cmd + Left Alt + R, and neither one worked. – ZeuxWarrior Apr 22 at 23:12
  • I'm using Google Chrome. – ZeuxWarrior Apr 22 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 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 at 23:26
  • 1
    It's Ctrl + ⌘ + R on Mac. I got it to show up now. Thank you. – ZeuxWarrior Apr 22 at 23:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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