Il est bien plus beau de savoir quelque chose de tout que de savoir tout d'une chose. [Blaise Pascal]

How to remove (blank) values in an Excel Pivot Table

You can call it perfectionism, but I hate when my reports are not looking good. One of the most irritating element are those (blank) text you may have on your Excel pivot tables.

I have tried some pivot table options, but seems not to work properly. I think this is not the correct usage of this option.

So, if you want to get rid of this, here is the procedure. Let’s play with conditional formatting:

1) Select the cells you want to remove (blank) text. It could be a single cell, a column, a row, a full sheet or a pivot table.
2) On the Home tab, go on Conditional Formatting, and click on New rule…

3) Select Format only cells that contain
4) Set Format only cells with: Cell Value > equal to > and input (blank) text

5) Click on Format…
6) On the Number tab, select Custom category, then type ;;; (3 semi-columns)

It’s a kind of magic…


  1. how make profit and loss projection in microsoft excel

    Microsoft Excel tutorial

    Visit this channel Microsoft tips

  2. I have read your blog. It is really helpful to work with excel. Continue shares more about excel.
    Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

  3. I too always learn something new from your post.
    Great work admin..Keep update more blog..
    Web design institute chennai

  4. I read your article and get very beneficial tips for making good quality links… Digital Marketing

  5. Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    Android Training in Chennai
    Ios Training in Chennai

  6. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.

    IBM BPM Online Training in Chennai
    IBM BPM Online Training


  7. thanks for sharing this article to us , it is very nice article thanks for your post,it is very nice post
    i am interesting of this post and i think every body like this post. best regards.
    Excel Training in Hyderabad

  8. Thanks for the post very useful