Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2   Create and Manage PivotTables: Format Data (Filter Blank Rows) Layout: Filter the (blanks) Well, you have been patiently waiting for this lesson for pages and pages. How do you hide the (blanks), the records that have no data-nothing, nada, de rien? Before You Begin: Select the PivotTable. The PivotTable Tools should be available. Try it: Filter the (blanks) Click on the Row Labels in the PivotTable. Unselect: (blank) Click on the Columns Labels, too. Unselect: (blank) You should see Filters on the Column and Row Labels in the PivotTable.   So far so good.

PivotTable Tools ->Design