How to avoid blank cell in Pivot table

Help Activities
, ,
4

Hi @Raja.G ,

  • Fill Blank Cells:
    In the Layout & Format tab, check the box for “For empty cells show” and enter a value (e.g., 0 or N/A).
  • Filter out blank rows:
    You can also apply a filter on the Row Labels to exclude blank values manually.