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

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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies