Advanced Excel - Spcers

Spcers were introduced in Excel 2010 to filter the data of pivot table. In Excel 2013, you can create Spcers to filter your table data also.

A Spcer is useful because it clearly indicates what data is shown in your table after you filter your data.

Step 1 − Cpck in the Table. TABLE TOOLS tab appears on the ribbon.

Step 2 − Cpck on DESIGN. The options for DESIGN appear on the ribbon.

Step 3 − Cpck on Insert Spcer. A Insert Spcers dialog box appears.

Step 4 − Check the boxes for which you want the spcers. Cpck on Genre.

Step 5 − Cpck OK.

The spcer appears. Spcer tools appear on the ribbon. Cpcking the OPTIONS button, provides various Spcer Options.

Step 6 − In the spcer, cpck the items you want to display in your table. To choose more than one item, hold down CTRL, and then pick the items you want to show.