Excel has separate controls for blank result cells, displayed errors, and a (blank) item in a PivotTable’s row or column labels. Use PivotTable Options for the first two; filter the relevant field to hide the label item. These changes affect what the PivotTable displays, not the source data.
Choose the control for what you want to hide
| What you see | Control | Effect |
|---|---|---|
| An error in a PivotTable result cell | Error-value display in PivotTable Options | Displays the error as blank or as replacement text you choose. |
| An empty result cell | Empty-cell display in PivotTable Options | Controls how empty result cells appear. |
| (blank) among row or column labels | Filter for that field | Hides the blank field item; clearing the filter restores it. |
| A zero | Zero-value display setting | Controls zero display separately from blanks and errors. |
| A field item with no data | Show items with no data setting, when supported | Microsoft documents this setting for OLAP data sources only. |
Display errors as blank cells
- Click a cell inside the PivotTable.
- Open PivotTable Analyze > Options. Depending on your Excel version, the options may be under a Layout & Format or Display area.
- Find the error-value display control, enable it, and leave its replacement box empty. Microsoft’s instructions say, “To display errors as blank cells, delete any characters in the box.” See Microsoft’s PivotTable layout and formatting instructions.
This changes the visible error in the PivotTable; it does not repair the calculation or change the underlying data.
Keep empty result cells blank
- Click inside the PivotTable and open PivotTable Analyze > Options.
- In the relevant options area, locate the control for displaying empty cells.
- Leave its replacement text empty to display empty results as blank.
This setting applies to empty result cells. It does not remove a (blank) category from a row or column field; filter that field instead.
Hide the “(blank)” row or column label
- Open the filter menu for the row or column field that contains (blank).
- Exclude the blank item from the field’s selection and apply the filter. Where available, you can select the item and use Filter > Hide Selected Items.
- To show it again, clear the field filter or select the blank item again.
The filter removes that item from the PivotTable view, not from the source data. Microsoft’s PivotTable filtering instructions also describe the Keep Only Selected Items command for displaying selected items.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware match#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Do not mistake zeros or items with no data for blanks
Zero values
A zero is a value, not an empty result or an error. Excel has a separate zero-value display setting; changing it does not control blank cells or errors. See Microsoft’s instructions for displaying or hiding zero values.
Items with no data
An item with no data is different from a blank cell or a blank field label. Microsoft’s documented Show items with no data option is limited to OLAP data sources. For PivotTable settings and their available options, see Microsoft’s PivotTable options guidance.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Why the menus may look different
Excel’s PivotTable tab and options can vary by release and platform, including Windows and Mac. If the exact labels differ, open PivotTable Options from the ribbon while a PivotTable cell is selected and look for the error-value and empty-cell display controls. Microsoft’s support pages cover multiple Excel versions, so use the labels available in your installed version.
Quick Recap
Rank #4
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errors
