totn Excel 2016 Pivot Tables

MS Excel 2016: Hide Blanks in a Pivot Table

This Excel tutorial explains how to hide empty cells which appear as blanks in a pivot table in Excel 2016 (with screenshots and step-by-step instructions).

If you want to follow along with this tutorial, download the example spreadsheet.

Download Example

Steps to Hide Blanks in a Pivot Table

To hide blank values in a pivot table in Excel 2016, you will need to do the following steps:

  1. First, identify the blank values in the pivot table that you wish to hide. In this example, we are going to hide all Order ID values that appear as (blank) in the pivot table.

    Microsoft Excel

  2. Click on the arrow to the right of the Order ID drop down box and un-select the checkbox next to the blank value. Then click on the OK button.

    Microsoft Excel

  3. Now whenever the Order ID is blank, that data will not appear in the pivot table. It will be hidden.

    Microsoft Excel