I am sure that you have come across a Pivot Table which has empty cell values and thought “What the hell is happening here?”

This is because your data source has blank cells for certain items, which happens from time to time.

This can be fixed in your Pivot Table and you can enter a value or text in place of that horrible looking and lonely blank cell.

You need to click in your Pivot Table > PivotTable Tools > Options > Options > Layout & Format > Format > For empty cells show: enter a value or text in this box.

Watch the tutorial below to see how this is achieved…

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Our pivot value for North is blank, let us change this!

 

STEP 2: Go to Pivot Table Tools > Options > Options

 

STEP 3: Set For empty cells show with your preferred value

All of your blank values are now replaced!

Format Empty Cells

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story.You can adjust the WIDTH of the line to make it as thin or thick as you like.You can make your line chart have a COMPOUND or DASH effect.You can also add...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values.The length of the data bar represents the value in the cell.  A longer bar represents a higher value.You have a Gradient Fill or a Solid Fill to choose from as well ...
Insert Blank Rows In a Pivot Table Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky...There is a cool little trick that most Excel users do not know about th...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...