Browse » Home
Saturday, May 19, 2012
How to Remove the Blanks from a Pivot Table Add
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.