Excel: Show Values for Empty Cells in PivotTable

Do you have a PivotChart in Microsoft Excel and you would like your empty cells to actually show something like "0" or "N/A" instead of being blank?

Right-click anywhere in the PivotTable and then click 'PivotTable Options'. Make sure you're in the 'Layout & Format' tab, and then place a checkmark next to 'For empty cells show:'. Use the text box just to the right to enter what you would like to appear for any empty cell. When you're done, press the 'OK' button to close the PivotTable Options window.

Your changes should go into effect right away.


Post a Comment