Microsoft Office Tutorials and References
In Depth Information
Similarly, you can select and delete the visible rows in the table, and the rows hidden by filtering will not be af-
You cannot, however, unhide rows that are hidden by filtering. For example, if you select all the rows in a table,
right-click, and choose Unhide, that command has no effect.
To remove filtering for a column, click the drop-down control in the row Header and select Clear Filter. If
you've filtered using multiple columns, it may be faster to remove all filters by choosing Home ⇒ Editing ⇒ Sort
& Filter ⇒ Clear.
Filtering a table with Slicers
Another way to filter a table is to use one or more Slicers. This method is less flexible, but more visually ap-
pealing. Slicers are particularly useful when the table will be viewed by novices or those who find the normal
filtering techniques too complicated. Slicers are very visual, and it's easy to see exactly what type of filtering is
in effect. A disadvantage of Slicers is that they take up a lot of room onscreen.
Slicers for tables is a new feature in Excel 2013. This feature was introduced in Excel
2010, but it worked only for pivot table filtering.
To add one or more Slicers, activate any cell in the table and choose Table Tools ⇒ Design ⇒ Tools ⇒ Insert Slicer.
Excel responds with a dialog box that displays each header in the table. 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
Figure 9-10 shows a table with two Slicers. The table is filtered to show only the records for Adams and Jenkins
in the Central area.