Setting Pivot Table Option - For Empty Cells Show

You can set different pivot table options using Aspose.Cells. One such option is “For empty cells show”. By setting this option, all empty cells in a pivot table are displayed as a specified string.

Setting Pivot Table Option in Microsoft Excel

To find and set this option in Microsoft Excel:

Select a pivot table and right-click.
Select PivotTable Options.
Select the Layout & Format tab.
Select the For empty cells show option and specify a string.

Setting Pivot Table Option Using Aspose.Cells

Aspose.Cells provides the PivotTable.DisplayNullString and PivotTable.NullString properties for setting the “For empty cells show” pivot table option.

Formatting Pivot Table

Pivot Table and Source Data Customize Globalization Settings for Pivot Table

Setting Pivot Table Option - For Empty Cells Show

Setting Pivot Table Option in Microsoft Excel

Setting Pivot Table Option Using Aspose.Cells

Related Articles