Skip to main content

TIP - 43 : Pivot table - Empty cell text filled


Pivot table - Empty cell text filled

We can set the text to be displayed on the blank or empty cells in the pivot table.

Step 1: Create pivot table and select the data for value field

Step 2: Then right click and select PivotTable options

Step 3: From the dialogue box PivotTable options, against “For empty cells show” - please enter text what you want to display.

Step 4: Then click on OK

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more