Home

Printing Pivot Tables in Excel for mac

%3CLINGO-SUB%20id%3D%22lingo-sub-469577%22%20slang%3D%22en-US%22%3EPrinting%20Pivot%20Tables%20in%20Excel%20for%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-469577%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20switched%20from%20Office%20365%20for%20Windows%20to%20Office%20365%20for%20Mac.%20In%20Excel%20for%20windows%20there%20was%20an%20option%20in%20Pivot%20Table%20field%20settings%20to%20insert%20a%20page%20break%20after%20each%20item.%20It%20would%20print%20each%20item%20and%20subtotal%20for%20that%20item%20on%20a%20separate%20page.%20In%20excel%20for%20mac%20that%20option%20is%20not%20present.%20In%20fact%2C%20there%20is%20no%20layout%20%2F%20print%20settings%20tab%20in%20the%20field%20settings%20pane.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20automatically%20insert%20a%20page%20break%20after%20each%20item%20without%20having%20to%20go%20through%20the%20entire%20table%20and%20manually%20insert%20a%20page%20break%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-469577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476955%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20Pivot%20Tables%20in%20Excel%20for%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476955%22%20slang%3D%22en-US%22%3E%3CP%3EI%20contacted%20MS%20and%20that%20feature%20is%20not%20available%20on%20the%20Mac%20version%20of%20Office.%20Yet%20another%20area%20where%20it%20seems%20parity%20between%20the%20platforms%20could%20be%20easily%20advanced.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20able%20to%20figure%20out%20a%20VBA%20workaround%20so%20that%20I%20don't%20have%20to%20go%20through%20the%20entire%20table%20and%20manually%20enter%20page%20breaks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC'mon%20MS%2C%20if%20you%20are%20going%20to%20offer%20a%20Mac%20version%20of%20office%2C%20don't%20treat%20it%20like%20a%20redheaded%20step-child.%3C%2FP%3E%3C%2FLINGO-BODY%3E
fhchap
New Contributor

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
Highlighted

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.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies