Forum Discussion

fhchap's avatar
fhchap
Copper Contributor
Apr 18, 2019

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?

Excel on Mac

1 Reply

  • fhchap's avatar
    fhchap
    Copper Contributor
    Apr 20, 2019

    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.

Resources