tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

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

See solution in other versions of Excel:

Question: In Microsoft 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.

Microsoft Excel

Right-click and select Hide from the popup menu.

Microsoft Excel

Now whenever the OrderID is blank, the data will be hidden in the pivot table.

Microsoft Excel