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

26 comments
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…


26 comments :

  1. how make profit and loss projection in microsoft excel

    Microsoft Excel tutorial

    Visit this channel Microsoft tips

    ReplyDelete
    Replies
    1. IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes. IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble.Final Year Projects for CSE

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining .

      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

      The Angular Training covers a wide range of topics including Angular Directives, Angular Services, and Angular programmability.Angular Training

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

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

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

    ReplyDelete
  5. 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

    ReplyDelete

  6. 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

    ReplyDelete
  7. Thanks for the post very useful
    https://www.slajobs.com/advanced-excel-vba-training-in-chennai/

    ReplyDelete

  8. The article provides good information and here i want to share some information about ibm bpm tool and iib tutorial

    ReplyDelete
  9. It's very useful article with inforamtive and insightful content and i had good experience with this information.Enroll today to get free access to our live demo session which is a great opportunity to interact with the trainer directly which is a placement based Salesforce training India with job placement and certification . I strongly recommend my friends to join this Salesforce training institutes in hyderabad practical course, great curriculum Salesforce training institutes in Bangalore with real time experienced faculty Salesforce training institutes in Chennai. Never delay to enroll for a free demo at Salesforce training institutes in Mumbai who are popular for Salesforce training institutes in Pune.

    ReplyDelete
  10. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. this

    ReplyDelete
  11. Thanks a lot for sharing a valuable blog on IBM BPM. I was browsing through the internet looking for IBM BPM training and IBM BPM Interview Questions and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information here about IBM BPM training and IBM BPM Interview Questions

    ReplyDelete
  12. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data science training Hyderabad

    ReplyDelete
  13. Really too good! This is much more helps to grow my knowledge. I got huge info in this blog, the author was done the well said and I like this blog.

    python Training in chennai

    python Course in chennai


    ReplyDelete
  14. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data scientist course in delhi

    ReplyDelete
  15. I was basically inspecting through the web filtering for certain data and ran over your blog. I am flabbergasted by the data that you have on this blog. It shows how well you welcome this subject. Bookmarked this page, will return for extra. data science course in jaipur

    ReplyDelete
  16. That is nice article from you , this is informative stuff . Hope more articles from you . I also want to share some information aboutBest MicroNutrients Company in India

    ReplyDelete

Note: Only a member of this blog may post a comment.