Configure slicers with the Add Slicer and Edit Layout buttons.
The Add Slicer button in the Slicer pane opens the standard Slicer design form. You can create workbook slicers the same way you would create sheet-based slicers. The image below shows the slicer pane.
The Edit Layout button allows you to configure the slicer order and the padding between individual slicers. It also allows slicers to be visible or hidden on specific sheets. For example, you may wish to conceal a slicer for a particular sheet that is not used.
To size the slicers, right-click the slicer and turn on move/size as you would for embedded slicers.
