Recommended article: How to Delete Blank Rows in Excel (5 Easy Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Microsoft Excel courses > Displaying data for empty cells using Options For example, the PivotTable Tools Analyze tab may appear as PivotTable Analyze and the Options button may appear in a PivotTable drop-down menu. For Excel 365 users, Ribbon tabs may appear with different names. Note: Buttons and Ribbon tabs may display in a different way (with or without text) depending on your version of Excel, the size of your screen and your Control Panel settings. To remove blanks in pivot tables, you can set pivot table options to display data in empty cells, filter to remove blanks, apply conditional formatting, find and replace blanks, change pivot table design settings or clean up the source data. Sometimes, the word “blank” appears in brackets or parentheses in cells.

When you create a pivot table in Excel, blank cells may appear if you have blanks in your data source.

Hide or Change the Display of Blank Cells in Excel Pivot Tablesīy Avantix Learning Team | Updated April 5, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)