Excel Tip Split Pivot Table Filters Into Multiple Columns

****SUBSCRIBE***** its free :-)

****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com

Website http://www.howtoexcelatexcel.excel.com
Twitter https://twitter.com/howtoexcelatex
Pinterest http://www.pinterest.com/howtoexcelatexc/

Excel Tip- Split Pivot Table Filters Into Multiple Columns


Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk.

Here is how to make your Pivot Table layout look more balanced with Pivot Table Filters in separate columns.

*Right click anywhere inside the Pivot Table.
*Select Pivot Table Options.
*In Options Dialog Box- Layout and Format go to the setting- ‘Report filters fields per column’
*Change this setting to how many filter fields you want in each column in the example it is 1.

In my example I am choosing 1 per column to give a neater and more easily navigable Pivot Table.

To reverse this back to stacked Pivot Table Filters
*Right click anywhere inside the Pivot Table.
*Select Pivot Table Options.
*In Options Dialog Box- Layout and Format go to the setting- ‘Report filters fields per column’
*Change this setting to how many filter fields you want in each column change this back to 0.