This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
My source data has empty cells. When I PT this data - the PT shows "(blank)" for the empty cells. How can I keep the cells "empty" in the PT. I do not want to manually filter and uncheck (blank) as this removes other data which is needed.
TIA,
PS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Excel 2007/2010 PivotTable
Show blank cell instead of (blank)
in RowField/ColumnField item labels.
http://c3017412.r12.cf0.rackcdn.com/01_23_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
I struggled with this problem, having an extra line in my pivot table and column in my chart titled "blank" and it looked messy. I figured out that you could right click on the "blank" line on the table and hover over 'Filter', then select "Hide selected items". The "blank" portion will disappear. Yes!
Is there a way to do this without modifying the data?