Hi,
I am trying to remove the blank fields from count in the row labels of a pivot table. Have tried numerous ways to do this but unable to find a solution. Any help would be greatly appreciated.
Example attached.
Thanks,
Erica
Hi,
I am trying to remove the blank fields from count in the row labels of a pivot table. Have tried numerous ways to do this but unable to find a solution. Any help would be greatly appreciated.
Example attached.
Thanks,
Erica
Remove (blank) cells in PivotTable
In order to remove (blank) cells and change them to empty cells, follow these steps.
Insert PivotTable.
Check all the PivotTable Fields.
Change the PivotTable to the classic layout (or keep the standard one if you prefer).
Click inside the PivotTable and Press Alt + A to select all PivotTable data.
Choose Home >> Styles >> Conditional Formatting >> New Rule.
Choose Format only cells that contain.
In Format only cells with, choose Cell Value, and equal to, then type (blank).
Click the Format…
Choose the Number tab and Custom
Inside the Type field, insert three semicolons.
Click OK.
This rule replaced all strings consisting (blanks) to empty spaces.
Asha Kanta Sharma
Guwahati, India
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks