• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Gadgets

How to Hide Blanks in Pivot Table

By: Waseem Patwegar

Blank values in a Pivot Table look unnecessary and they can be distracting. You will find below the steps to hide Blanks in Pivot Table.

Hide Blanks in Pivot Table

Hide Blanks in a Pivot Table

When you create a Pivot Table and the source data contains empty cells, the empty cells are reported as “Blank” in the pivot table.

Depending on the organization of your Pivot Table, the Blanks can appear in Rows, Columns or in both Columns and Rows.

In most cases, “blank” in a Pivot Table serve no purpose at all and you can easily Hide Blanks in Pivot Table by following the steps below.

1. The first steps is to identify the Blank values that you want to hide in a Pivot Table. In our case, we have Blanks both in Row and Column of Pivot Table and they serve no purpose.

Blank in Pivot Table Row and Column

2. To hide blanks in Pivot Table Rows, click on the Down-arrow located next to “Row Labels”. In the drop-down, uncheck the little box located next to blank and click on the OK button.

Hide Blank in Pivot Table Rows

This will hide the Blank appearing in Pivot Table Rows. Depending on the Layout of your Pivot Table, this step may also hide the Blank appearing in Pivot Table Columns.

3. If you still find Blank appearing in Pivot Table Column, click on the Down-arrow located next to “Column Labels” and Uncheck the little box located next to Blank in the drop-down menu.

Hide Blank in Pivot Table Columns

4. From now, whenever the Quantity is blank in date source, the data will not be reported as “Blank” in the Pivot Table.

Related
  • How to Create Two Pivot Tables in Single Worksheet
  • How to Add or Remove Subtotals in Pivot Table

Primary Sidebar

Twitter
Facebook

Popular Now

  • How to Boot Windows 10 From USB Drive
  • How to Backup iPhone to iCloud
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Setup Chromecast on Android and iPhone

Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks



About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2020 @Techbout.com · All Rights Reserved