Awais, but online.

How do I permanently remove “(blank)” from an Excel pivot table?

Uncheck (blank) in the filter drop-down of the field that shows it. That hides the row. If you want it gone for good, the cause is almost always empty or empty-looking cells in the source data, so fix them there.

The setting named “For empty cells show” does not do this job. It controls how empty value cells look, not row or column labels.

Method 1: Hide it with the filter

  1. Click the small arrow on the Row Labels (or Column Labels) header of the pivot table.
  2. Scroll to the bottom of the list of items.
  3. Clear the checkbox next to (blank).
  4. Click OK.

The row disappears from view. Be aware that the hidden item’s data is still part of the source, and totals can change depending on how your pivot is built, so compare the grand total before and after. Also check the pivot after you refresh it, especially if new data arrives. A Microsoft Q&A poster reported that hiding blanks through filters did not hold when other filters were changed.

Method 2: Fix the source data

A volunteer moderator in that same thread put it plainly: the filters only show what is in the data, so to stop blanks appearing you have to remove them from the data. Common causes:

  • Truly empty cells in the column you use as a label.
  • Formulas that return an empty string, such as =IF(A2>10,B2,””). The cell looks empty but still groups under (blank).
  • A source range that is too wide and includes empty rows below your data.
  • Cells that contain only a space or a non-printing character.

Fill the gaps with a real label such as “Unknown” or “Not entered”, delete empty rows from the range, or turn the source into an Excel Table so the range tracks your data. Then right-click the pivot and choose Refresh.

Method 3: Replace the (blank) label

Click the (blank) label in the pivot and type a new name over it, for example “Unassigned”. This does not remove the group, but it makes it readable. Use it when the blank group has meaning and you want to keep it.

What “For empty cells show” does

  1. Right-click the pivot table and choose PivotTable Options.
  2. Open the Layout & Format tab.
  3. Type a value, such as 0, in For empty cells show, then click OK.

This fills empty value cells in the body of the pivot with your chosen text or number. ExcelDemy notes that it only changes how blanks display and does not remove the rows. Use it for gaps in numbers, not for the (blank) label.

Which method should I use?

  • Quick report for today: use the filter.
  • A report you refresh often: fix the source data.
  • Blank group is meaningful: rename it.

Results can vary a little between Excel versions, so check the pivot after each change.

Sources

Last checked: 18 October 2026