Part I: Getting Started with Excel
If your table has more than one slicer, it’s filtered by the selected buttons in each slicer. To
remove filtering for a particular slicer, click the Clear Filter icon in the upper-right corner
of the slicer.
Use the tools in the Slicer Tools Options Ribbon to change the appearance or layout of a
slicer. You have quite a bit of flexibility.
Figure 4.27 shows a table with two slicers. The table is filtered to show only the records for
Adams, Barnes, Chung, and Hamilton in the Downtown area.
FIGURE 4.27
The table is filtered by two slicers.
Changing the table’s appearance
When you create a table, Excel applies the default table style. The actual appearance
depends on which document theme is used in the workbook (see Chapter 5, “Formatting
Worksheets”). If you prefer a different look, you can easily apply a different table style.
