Layout: Filter the Blanks

Well, you have been patiently waiting for this lesson for pages and pages. How do you hide the blank lines? Here are the steps to Filter the Blanks, at last.

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

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Filter Blank Rows