I've got a Google Sheets document with a lot of data that I often need to sort. Google Sheets offers a sorting feature but I'd personally like button on the header that allows sorting of the rows based on that header, ascending or descending. Another thing that makes this maybe harder is that I have 2 rows working as the header.

Is this possible? How can it be done?

1 Answer 1


Try Data > Filter views. For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.

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.