Change the Report Filter Layout

Change the Report Filter Layout

By default, when you add Report Filters to a pivot table, they are shown in a single vertical list, above the body.

reportfilterlayout01

If you add several filters, that list can get rather long, and it pushes the data down the worksheet.

To save space at the top of the worksheet, you can change the Report Filter layout. You can either:

  • Set a limit for the rows in the vertical list, and create more vertical lists, if necessary
  • Switch to a horizontal layout, with the Report Filters across the row

Change the Layout

  1. To change the Report Filter layout
  2. Right-click a cell in the pivot table, and click Pivot Table Options
  3. Click the Layout & Format tab
Set Limit for Rows in the Vertical List
  1. The ‘Display Fields in Report Filter Area’ is set for ‘Down, Then Over’
  2. In the ‘Report filter fields per column’ box, select the number of filters to go in each column.
    NOTE: The default setting is zero, which means “No limit”
  3. Click OK

In the screen shot below, the number of fields per column is set at 4. The 5th field – Product — is at the top of the second set of filters.

reportfilterlayout04

Switch to Horizontal Layout
  1. In the ‘Display Fields in Report Filter Area’ drop down list, click ‘Over, Then Down’
  2. In the ‘Report filter fields per row’ box, select the number of filters to go across each row.
    NOTE: If the number is set at zero, all the filters will be shown in one row.
  3. Click OK

In the screen shot below, the number of fields per row is set at 3. The 4th field – Category – begins the second row of filters.

reportfilterlayout03

Watch the Video

To see the steps for changing the Report Filter layout, please watch this short video tutorial.

_______________

10 thoughts on “Change the Report Filter Layout”

  1. Far out, Deb…it’s astounding what you know. That is a new one on me. Just yesterday I was looking at those settings thinking “I wonder what those do?” But didn’t wonder enough to get on google and find out.

    That’s the beauty of your blog…something for everyone.

  2. This site is amazing it has a lot of excellent tips to develop new projects Congratulations my dear Debra¡¡¡¡ Regards

  3. I’m totally on Jeff’s side
    This Debra’s blog is so beautiful that her article and video are just right there where we are really wondering 🙂 . Always Thanks, Debra. – From Korea.

  4. After using Excel for 20+ years, I continue to be amazed by what I don’t know! I use pivot tables all the time but never knew this existed. Thanks Debra!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.