Someone created some filters for columns of data on a Google Sheet. But they created buttons for these filters on the sheet. Can someone tell me how this was done? I've attached a screenshot of what I'm trying to ask/convey.

enter image description here

2 Answers 2


Look into slicers.

Select your range, then go to Data > Add a Slicer.


these are slicers.

they have used slicer to create these.

go to "Data" tab from menu .. "add Slicer"

thank you

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.