Slicer Customizations for Slicers on Your Excel Dashboard

By Michael Alexander

If you’re going to use slicers on an Excel dashboard, you should do a bit of formatting to have your slicers match the theme and layout of your dashboard. The following discussion covers a few formatting adjustments you can make to your slicers.

Size and placement of slicers

A slicer behaves like a standard Excel shape object in that you can move it around and adjust its size by clicking it and dragging its position points.

Adjust the slicer size and placement by dragging its position points.

Adjust the slicer size and placement by dragging its position points.

You can also right-click the slicer and select Size and Properties from the menu that appears. This brings up the Format Slicer pane, as shown, allowing you to adjust the size of the slicer, how the slicer should behave when cells are shifted, and whether the slicer should appear on a printed copy of your dashboard.

The Format Slicer pane offers more control over how the slicer behaves in relation to the worksheet

The Format Slicer pane offers more control over how the slicer behaves in relation to the worksheet it’s on.

Data item columns in slicers

By default, all slicers are created with one column of data items. You can change this by right-clicking the slicer and selecting Size and Properties from the menu that appears. This brings up the Format Slicer pane.

Under the Position and Layout section, you can specify the number of columns in the slicer. Adjusting the number to 2, as demonstrated here, forces the data items to be displayed in two columns, adjusting the number to 3 forces the data items to be displayed in three columns, and so on.

Adjust the Number of Columns property to display the slicer data items in more than one column.

Adjust the Number of Columns property to display the slicer data items in more than one column.

Other slicer settings

Right-clicking your slicer and selecting Slicer Settings from the menu that appears activates the Slicer Settings dialog box, shown here. With this dialog box, you can control the look of the slicer’s header, how the items in your slicer are sorted, and how filtered items are handled.

The Slicer Settings dialog box.

The Slicer Settings dialog box.