Microsoft Office Tutorials and References
In Depth Information
Creating a Standard Slicer
You can also right-click the slicer and select Size and Properties, which accesses the Format Slicer
pane illustrated in Figure 16-11. Here you can adjust the size of the slicer, how the slicer behaves
when cells are shifted, and whether the slicer will be shown when the worksheet is printed.
Figure 16-11: The Format Slicer pane offers more control over how the slicer behaves in relation to the worksheet
Data item columns
By default, all slicers are created with one column of data items. You change this by right-clicking the
slicer and selecting Size and Properties. This accesses the Format Slicer pane. Under the Position and
Layout section, you specify the number of columns. Adjusting the number to 2 (as demonstrated in
Figure 16-12) forces the data times to be displayed in two columns. Adjusting the number to 3 forces
the data items to display in three columns, and so on.
Figure 16-12: Adjust the Number of Columns property to display the slicer data items in more than