Removing blanks from the Pivot Table in Microsoft Excel

Asked By Abacahin San 0 points N/A Posted on - 06/06/2020

Is there any way to remove the word “blank” appearing in cells in the  Pivot Table in Microsoft Excel?

• Status:
• Question Views: 44
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Microsoft Others

Best Answer by

Go To Solution

Answered By Rodney Sid 0 points N/A #330153

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 [;;;].

About Rodney Sid

Questions
15

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/06/2020
• Question Category: Microsoft Others