'Is there a way to add range slicer to Excel worksheet for data filtering?
I'd like to add range slicers to an Excel worksheet for quick data filtering. However, I could not find such a control from Excel, and based on quick Googleing, it seems to be included in Power BI. I'd assume you can either get it from some (free) add-in or create it yourself.
Many thanks for anyone who can help on this!
Solution 1:[1]
Yes, you can add slicers in Excel. You just need to convert your data to a table first.
- Select your data
- Press ctrl + t or go to Insert -> Table.
- Then select if your table has headers and click OK.
Now you will see the options to add slicers.
- Still with your table selected (or any cell inside it), navigate to Insert -> Slicer.
- Mark the column you want and it is done.
You can find a good explanation on this link. But fell free to reach out in the comments.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Fernando Barbosa |