How to remove blank rows in Pivot Table

👤 Authored by Lashmi Bai Ravindrapandian
📅 Published on Mar 6, 2022

When there are blanks in the dataset, the pivot table also has cells with “blank strings” as below.

So, how to remove them. It is so frustrating to read the data right?

There is a solution for this. By using the conditional formatting function, you can eliminate the blanks as below.

1. Select the entire pivot table ( Shortcut Ctrl+A)
2. Then select New Rule
3. Click “format only cells that contain”
4. Select the cell value as Blank
5. Under Format tab, Type ;;; under custom formatting
6. This rule will make the blank cells real blanks.

All the blank strings are replaced with blank cells as below.