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

Go to Print Menu (a dumb place to put it, it should be in page setup if it goes anywhere).

View this youtube movie and see if this is what you need. 

Custom Size

Might look better if you click on the YouTube symbol at the bottom of the movie and play full size.

NOTE: I am using an HP Printer when you go to Print menu the Print Driver for your printer shows. You know how you went custom sizes previously with your Printer. So Procedure to get there is shown in the movie the "Look & Fill" will be different.

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and does not reflect upon my position as a Community Moderator.

Answer 3

Dear Phillip,

Thank you so much for taking the time to explain! I also found your solution, but the problem is that this does not actually change the page size (the content part). It does not let me work in the actual selected (custom) size.

Previously I could go through a similar process and the worksheet dimensions would change to my custom size. In your solution, it just changes the print setting, but my data is then just scaled differently. It does not actually adjust the dimensions of the worksheet.

I'm afraid it's a feature that's killed in 2016.

Answer 4

serious, how do i go back. why would you remove this.

Answer 5

Thanks for the explanation. And it did work for me. I now have legal, letter, A4 sizes again. Best Regards.