anything in Excel...

It's Excel-o-lozy...

Super trick - Removing "(blank)" from Pivot

Pivot, all we know, how to insert...

But an annoying thing is to remove "Blanks" in header column.

It's easy, Drop down the Header column filter and uncheck "(blank)".

and done... :)

No... try to refresh Pivot and if there is a new item in Header column, it wont pop-up in table..
Reason is that when we uncheck "(blank)", it doesn't mean that we are not showing "(blanks)", it means we are showing Checked items and New item is not automatically checked on refresh.

So simply do as follows:

Drop down...
Label Filter...
Choose "Does Not equal" = "(blank)"...


Voho... done

0 comments: