Page 48 - Excle-En-V3

5.8.2 - Add slicer (filter for insert slicers table)

A slicer is a way to filter data in a table that has been defined or selected.

Figure 51: Inserting a slicer

This is done through the Table Design tab, and from the “Tools” group, choose
“Insert Slicer” as in Figure (51). A list appears from which we select the column or
table title in the light of which we want to filter the data. More than one column
name can be chosen.

Figure 52: Selecting slicers (table filtering)

After selecting the columns, we click OK. Windows for the selected columns

appear, including the data in the column without repetition. When we select a

statement, only the record associated with this statement appears in the

table. To cancel the filter, click on the icon

40 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024