Wednesday, July 6, 2016

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…

9 commentaires:

shohan tim said...

how make profit and loss projection in microsoft excel

Microsoft Excel tutorial

Visit this channel Microsoft tips

Jhon Abraham said...

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

Jeremy Cottino said...

Thanks for the comment Jhon

anitha a said...

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

sukere said...

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

sunitha vishnu said...

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

Deepika Analy said...

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

mahi eswari said...

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

viral newz said...

you can download the lates Microsoft office 2019 download full version here

Post a Comment