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: Change how empty cells are displayed in a pivot table in Excel 2010

See solution in other versions of Excel:

Question: In Microsoft Excel 2010, I don't want to see empty cells in a pivot table. How do I replace all empty cells with another value?

Answer: First, let's explain what an empty cell is. In the example below, we have order #10250 that does not have any quantity (row 5 in spreadsheet). Therefore, the quantity is showing as a blank cell.

Microsoft Excel

We'd like to replace all empty cells with the value "n/a". To do this, right-click on the pivot table and then select "PivotTable Options" from the popup menu.

Microsoft Excel

When the PivotTable window appears, check the checkbox called "For empty cells show". Then enter the value that you wish to see in the pivot table instead of the empty cell. Click on the OK button. In this example, we want all blank cells to show as "n/a".

Microsoft Excel

Now when we return to the pivot table, we see "n/a" as the quantity value for order #10250.

Microsoft Excel