How to remove the blanks from a pivot table add-in

Written by erika dean
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open Excel and open "Pivot Table Options" in the Excel ribbon by clicking anywhere on the Pivot Table.

  2. 2

    Click "Pivot Table Options" to open the options box so you can make changes to the Pivot Table settings.

  3. 3

    Click the "Layout & Format" tab and look to the "Format" section.

  4. 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.

  1. 1

    Click on the Pivot Table report to open "Pivot Table Options" in the Excel ribbon.

  2. 2

    Look to the "Active Field" section of the ribbon and click "Field Settings."

  3. 3

    Click the "Layout & Print" tab when the "Field Settings" box opens.

  4. 4

    Uncheck the box next to "Insert blank line after each item label" and click "OK." Blank lines will no longer appear after rows.

  1. 1

    Select the item that has a blank from the Pivot Table report.

  2. 2

    Click the "Design" tab located in the Excel ribbon and then click "Blank Rows."

  3. 3

    Select "Remove blank line after each item label" and blank lines will no longer appear after item labels in the Pivot Table.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.