Excel: Hide empty cells in a pivot table in Excel 2003/XP/2000/97

Also learn how to hide empty cells in a pivot table in Excel 2007.

Question:  In Excel 2003/XP/2000/97, how do I hide empty cells in a 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.