Excel: Hide empty cells in a pivot table
Question: How do I hide empty cells in an Excel pivot table? Answer: To hide empty cells in a pivot table, select the empty cell in the pivot table.
|
Right-click and select Hide from the popup menu.
|
Now whenever the OrderID is blank, the data will be hidden in the pivot table.
|
