Chapter 4: Working with Excel Ranges and Tables
4
FIGURE 4.26
Use the Insert Slicers dialog box to specify which slicers to create.Place a check mark next to the field(s) that you want to filter. You can create a slicer for
each column, but that’s rarely needed. In most cases, you’ll want to be able to filter the
table by only a few fields. Click OK, and Excel creates a slicer for each field you specified.A slicer contains a button for every unique item in the field. In the real estate listing
example, the slicer for the Agent field contains 14 buttons because the table has records for
14 different agents.Slicers may not be appropriate for columns that contain numeric data. For example, the real estate listing table has
78 different values in the List Price column. Therefore, a slicer for this column would have 78 buttons (and there’s no
way to group the values into numeric ranges). This is an example of how a slicer is not as flexible as normal filtering
using Filter Buttons.
To use a slicer, just click one of the buttons. The table displays only the rows that have a
value that corresponds to the button. You can also press Ctrl to select multiple buttons and
press Shift to select a continuous group of buttons, which would be useful for selecting a
range of List Price values.