Pinterest Pixel

Change Layout of Report Filter

The report filter is very useful when it comes to working with your Pivot Table. By default,... read more

Download Excel Workbook
Bryan
Posted on

Overview

Change Layout of Report Filter | MyExcelOnline Change Layout of Report Filter | MyExcelOnline

The report filter is very useful when it comes to working with your Pivot Table. By default, when you add report filters in Pivot Table, they are displayed in a single vertical list.

Change Layout of Report Filter

At first, when I used that, I thought the layout is completely fixed. And nothing could be further from the truth! There are options that allow you to customize the report filter layout.

 

Download the workbook below to follow along with the tutorial on how to change layout of Report Filters in Pivot Table:

download excel workbookChange-the-layout-of-a-report-filter.xlsx


Here is our Pivot Table and you can see the layout of our filters:

Change Layout of Report Filter

 

Method 1: Switch to Horizontal List

STEP 1: Let us change that! Go to PivotTable Analyze > PivotTable > Options

Change Layout of Report Filter

STEP 2: Select Over, Then Down, and click OK

Change Layout of Report Filter

The layout of our filters has changed!

Change Layout of Report Filter

All the filters are now displayed in a horizontal format next to each other! If you want to change the layout back to vertical but this time you can limit the number of rows in the list.

Let’s see how it can be done!

 

Method 2: Limit Row in Vertical Format

STEP 1: Let us try another setup. Go back to PivotTable Analyze > PivotTable > Options

Change Layout of Report Filter

STEP 2: Set it to Down, Then Over, and set the Report filter fields per column to 2.

Change Layout of Report Filter

You now have a 2-column layout for your filters!

Change Layout of Report Filter

 

If you want a vertical arrangement, you can select Down, Then Over option

Change Layout of Report Filter

For a horizontal arrangement, you can select Over, Then Down option.

Change Layout of Report Filter

 

Click here to know Top 50 things that you can do with Excel Pivot Table!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Change Layout of Report Filter | MyExcelOnline Change Layout of Report Filter | MyExcelOnline
Change Layout of Report Filter | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Show The Percent of Column Total With Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...