But you’re free to also add a slicer to a table.
Slicers provide the same function as filters.
They let you selectively display rows based on field values.
However, instead of drop-down menus, slicers provide large, friendly buttons that are always visible.
This table holds basic employee information.
Slicers buttons work just like filters.
In fact, filters and slicers work together and stay in sync.
Notice, as I click through various departments, Excel filters the table.
Likewise, if I make a selection in the filter, the slicer responds accordingly.
To enable more than one button at a time, hold down the Control key as you click.
you’re able to also use the Shift key to enable all buttons between two buttons.
Again, the Filter is updated to match the slicer.
it’s possible for you to add more than one slicer to a table.
when you’ve got more than one slicer, they work together.
Or you might use the Clear button on the ribbon.
To remove a slicer from your worksheet, just go for the slicer and delete.
