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)
I have Excel 2013.
How do I remove the text (blank) from all of my cells that do not have any data in it so my pivot table looks nicer. I have tried going into Pivot Table Options, Layout and Format and checking 'For Empty Cell Row' then placing a - in the box but this does not work.
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.
Hi,
Where is the word Blank appearing in your Pivot Table image? I do not see it. Upload your workbook to OneDrive and share the download link here.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Hi,
In that case, just type any text over the word Blank.
Ashish, if I filter and uncheck the "blank" box, it removes rows that have data in it. So, filtering will not work.
Hi,
I think that setting applies only to the numbers in the value area section of the Pivot Table. To remove the word Blank from the row or column labels, use Filter.