Show Zero in Empty Pivot Table Value Cells

For an Excel pivot table, if no data is entered for some items, there will be blank cells in the pivot table values area.

In the example shown in this video, no Banana Bars were sold at stores 3062 or 3659, so those cells are empty in the pivot table.

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

Watch this short video to see the steps.

Visit this page on my Contextures site, for details, and written steps.

Video Timeline
0:00 Introduction
0:27 Show Zero in Empty Value Cells
0:53 Show N/A in Empty Value Cells

Instructor: Debra Dalgleish, Contextures Inc.
#ContexturesExcelTips #ExcelQuickTips

[excelisfun]

I agree with James Perry! All your videos are amazing!

[scwong]

Fixed my report issues in 2022, thanks!

[TickyMN]

Perfect! Such a simple and logical setting. I wish zero was the default. Thank you!

[contextures]

Thanks! It's one of those useful, but well-hidden pivot table settings.

[contextures]

@ExcelIsFun and @James Perry, thank you!

[jamesPerry]

All of ur vid r great!
Thank u 4 sharing.

[ishthiaqshaik]

for me neither the blank nor the zero values are displayed the field is missing how do I rectify this??

[reneche]

Thank you very much....this is what i was looking for