Removing blanks from the Pivot Table in Microsoft Excel

Asked By 0 points N/A Posted on -

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

SHARE
Best Answer by Blankenship Hartzler
Answered By 0 points N/A #330153

Removing blanks from the Pivot Table in Microsoft Excel

qa-featured

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

Login/Register to Answer

Related Questions