You can clear slicer filter display all the data your worksheet

Define a filter using a slicer
1 In the slicer, do any of the following:
a Click an item to display just its related values.

b While pressing the Ctrl key, select multiple items to display those items’ related values.

Clearing and removing slicers

TIP You can also clear a slicer’s filter by clicking the slicer and

then pressing Alt+C.