Search Contextures Sites
Custom Search


Related Tutorials

Pivot Table Introduction

Pivot Table Article Index

Pivot Table Video Index





Learn how to create Excel dashboards.





Excel Pivot Table Options

Change the option settings to adjust the pivot table's appearance and behaviour.

Pivot Table Options

Video: Show Zero in Empty Cells

Show Zero in Empty Cells

More Pivot Table Tutorials

Pivot Table Options

In addition to the pivot table settings on the Ribbon, you can make changes in the Pivot Table Options dialog box.

To access this, right-click on any cell in the pivot table, and click PivotTable Options.

PivotTableOptions in popup menu

Video: Show Zero in Empty Cells

To see the steps for showing a zero in empty pivot table cells, please watch this short video tutorial. The written instructions are below the video.

Show Zero in Empty Cells

If no data is entered for some items, there will be blank cells in the pivot table. In the screen shot below, no Banana Bars were sold at stores 3062 or 3659, so those cells are empty.

empty cells in pivot table

Instead of leaving these cells blank, you can change a pivot table option, to show a zero, or other characters, in those cells:

To change what appears in empty cells, follow these steps:

  1. Right-click a cell in the pivot table, and in the popup menu, click PivotTable Options.
  2. In the PivotTable Options dialog box, click the Layout & Format tab
  3. In the Format section, add a check mark to For Empty Cells, Show
  4. In the text box, type a zero, or other characters, such as N/A
  5. Click OK to close the dialog box.

empty cells in pivot table

The pivot table will change, to show the characters that you entered. In the screen shot below, N/A shows in the empty cells.

empty cells in pivot table

PivotPower Premium Add-in

NOTE: If you have purchased a copy of my PivotPower Premium add-in, you can store some of the options in your Preferred Settings window. Then, after you create a new pivot table, just click the Apply Prefs commandto change all of the stored settings, with a single click.

You can see a few key features of the PivotPower Premium add-in in this short video.

More Pivot Table Resources


Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures

Search Contextures Sites



Privacy Policy


Contextures Inc., Copyright 2016
All rights reserved.


Last updated: May 30, 2016