How to Remove the Blanks from a Pivot Table Add-In
If you downloaded a Pivot Table add-in and noticed blanks in the Pivot Table, you may want to remove them to make the Pivot Table look nicer. You can remove blank cells and blank lines following rows or item labels in a Pivot Table. You only need to click on the Pivot Table add-in to get started.
Other People Are Reading
Instructions
-
Remove Blank Cells
-
1
Open Excel and open "Pivot Table Options" in the Excel ribbon by clicking anywhere on the Pivot Table.
-
2
Click "Pivot Table Options" to open the options box so you can make changes to the Pivot Table settings.
-
-
3
Click the "Layout & Format" tab and look to the "Format" section.
-
4
Uncheck the box next to "For empty cells show:" and then click "OK." Blank cells will no longer show up in the Pivot Table add-in.
Remove Blanks from Rows
-
5
Click on the Pivot Table report to open "Pivot Table Options" in the Excel ribbon.
-
6
Look to the "Active Field" section of the ribbon and click "Field Settings."
-
7
Click the "Layout & Print" tab when the "Field Settings" box opens.
-
8
Uncheck the box next to "Insert blank line after each item label" and click "OK." Blank lines will no longer appear after rows.
Remove Blanks from Item Labels
-
9
Select the item that has a blank from the Pivot Table report.
-
10
Click the "Design" tab located in the Excel ribbon and then click "Blank Rows."
-
11
Select "Remove blank line after each item label" and blank lines will no longer appear after item labels in the Pivot Table.
-
1
