Most of the time, you probably use a pivot table on your computer, but occasionally you might need to print one, to share with other people in your company.
Onscreen, pivot tables can get quite wide, and you can scroll back and forth, to see everything. In the pivot table shown below, there are 3 Values fields, and they are repeated for each of the items in the Column field.
Instead of a horizontal layout, if you need to print a pivot table, it is easier to have the report in a vertical layout, so the data runs down the page.
Change the Values Fields
One way to change the pivot table layout to vertical is to move the Values fields into the Row Labels area. By default, the values go into the Columns area, where they can stretch across the page. It’s easy to change that though, and the results can be easier to print.
In the screen shot below, the Values fields have been moved to the Row area, and the pivot table is much narrower, and easier to read, and to print.
Video: Change Pivot Table Values Fields Layout
Watch this video to see how to change the values fields to vertical layout, for better results when printing.
_____________________