Forum Discussion
fhchap
Apr 18, 2019Copper Contributor
Printing Pivot Tables in Excel for mac
I recently switched from Office 365 for Windows to Office 365 for Mac. In Excel for windows there was an option in Pivot Table field settings to insert a page break after each item. It would print each item and subtotal for that item on a separate page. In excel for mac that option is not present. In fact, there is no layout / print settings tab in the field settings pane.
How can I automatically insert a page break after each item without having to go through the entire table and manually insert a page break?
1 Reply
Sort By
One option is to change the rule to one of type 'Use a formula to determine which cells to format', with formula
=AND(H7<F7, H7<>"")
Another option is to keep the rule with Cell Value less than =F7, and to add a new rule of type Cell Value equal to ="" and No Fill color and Automatic font color.
- packieBrass Contributor
I have used your first solution as it works best with a formatted table.
Thankyou
- fhchapCopper Contributor
I contacted MS and that feature is not available on the Mac version of Office. Yet another area where it seems parity between the platforms could be easily advanced.
I was able to figure out a VBA workaround so that I don't have to go through the entire table and manually enter page breaks.
C'mon MS, if you are going to offer a Mac version of office, don't treat it like a redheaded step-child.