NOTE: This question is NOT about how to sort rows by selecting them and then choosing Data->Sort Range

Rather, I want to know if it's possible to add or enable a UX here there's a sort button on each column's heading

Here's what the top of my sheet looks like now

enter image description here

And here is what I want it to look something like, each column having a button that sorts by that column

enter image description here

Note: I'm not looking for a scripting solution (I'm sure I could write that). I'm asking, is there some basic feature I can use that will provide a UX where I can trivially sort by column? I feel like this is probably one of those basic features that lots of people use and I'm embarrassed I don't know how to enable it.

1 Answer 1


The built-in function that does that is called "Create a filter"

Click on the menu Data > Create filter or on the Google Sheets toolbar look for the funnel icon and click on it.


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.