An EASY trick to remove "blanks" from a pivot table that are NOT in values area
When information is missing in a pivot table, then blanks are displayed instead. The intuitive way to remove the unnecessary blanks from the pivot table would be to right click on it and under pivot table options check the box "For empty cells show" and leave it empty. But this will only affect the values area. Blanks in rows area will still remain. An easy trick to remove such blanks is to click on a cell containing a blank, delete the blank in the formula bar, hit the spacebar (because the formula bar cannot be empty) and enter key. All blanks will be removed. This is a dynamic solution and if more blanks appear later in the pivot table after the next refresh, these will also be removed automatically.
For more contents like this, please subscribe to my channel.
#MsExcel #ExcelTips
Screenshots used with permission from Microsoft.