• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Hide Blanks in Pivot Table

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

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



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 2022 @Techbout.com · All Rights Reserved