How to add custom paper size in Excel 2016 (mac)

Question

In Excel 2011 I would create custom page sizes for my projects; this allowed me to create PDF's with any size I create for it (say 297mm x 2000 mm) — this is essential in my workflow for creating client reports.

This functionality seems to be disappeared in 2016 :(. The only place I can add a 'custom page size' is in the print settings, but this does not affect my actual sheet size (which stays on any off the default page sizes). This results in my 'design' spreading all over different pages. 

Please help, as this affects my whole business.

Looking forward.

Answer 1

I found this, it may help:

In this case, I am printing on a 4x6" label printer. I leave everything formatted as 8.5x11 and then go to print. I changed the print option to the paper handling section, check the scale to fit paper size box. And then change the destination paper size to the one I want. If you scroll to the bottom of the list you should be able to find your custom size.

Warranted, this is biggest failure of office 2016 and this solution is the most techneck i have seen in a while. But, it worked for me, so hopefully it helps you and any body else that stumbles into this solution. 

Answer 2

Thanks Phillip.  I think your answer has resolved all the printing problems I've had since I migrated to macOS about 18 months ago.

I haven't tested it yet against all my printing challenges, but the basic approach - forget paper handling settings in the Microsoft app and do it all in the macOS printer driver- is easy enough to follow.

This is  the first time I was able to print first time on long bond (8.5" * 13") without tearing my hair out and going through a ream of waste per single successful print.

At least this one time.  I'll test it against other scenarios as they arise.

My heartfelt thanks!