Removing blanks from the Pivot Table in Microsoft Excel

Removing blanks from the Pivot Table in Microsoft Excel

To remove the word “blank” occurring in the pivot table follows these given steps:

1. Select the cells which show the word “blank.” It can be a single cell, a column, a row, a full sheet, or just the pivot table.
2. Under the Home tab, go to Conditional Formatting, and select New Rule
3. Select the “Format only cells that contain.”
4. Set the rule description to Cell Value | equal to | and input “(blank)” text.
5. Click on Format
6. From the number tab, select the category as Custom, and then type three semi-colons [;;;].