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

This is not the solution and this does not work. Currently, it is not possible to do a DIN A0 Worksheet and print it out to DIN A0. The BUG is in Excel!!!!!

Answer 3

First, don't go by presets located with the Excel application. This a clear case of Microsoft messing with something they shouldn't. Adobe is going down the same path in Acrobat. The Printer set up should only be adjusted exclusively by the Print Driver. 

1. Avoid at all cost using those presets within the application.
2. Make sure you have the latest Print Driver for your printer.
3. Make sure the printer you have is capable of printing the size you need.

(For example, I recently had to buy a new Printer. I settled on Canon. I found out that they regular format, and large format printers.) 4. If you are using the same Printer (in the same office) on both PC's and Mac's, you need to have separate Print Drivers for each. Also if you must use the same printer, make sure you turn off the printer for about 30 seconds then turn back on to purge the PC Driver software from the printer or the Mac Print Driver before you aim to Print.

_________

Disclaimer:

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

Answer 4

I was trying to do the same thing as the original poster.  I have a large custom sized document - in my case 36"W x 13"H.  I usually like to just make a pdf of it.  But I also occasionally print it to our plotter, for which I have the latest drivers installed.  I am able to successfully print oversized documents from other non-office based applications on my MAC.  So, it seems to be an excel based problem.

When I am trying to make a PDF, my MAC doesn't ever give me the opportunity to specify a page size, so I have to rely on the page size supplied by Excel, which apparently does not allow the user to make a custom size?

If I want to print to the plotter, I can indeed make a custom size page in the print dialog for the plotter.  What ends up printing is multiple 36x13 pages, each with a portion of the whole document in the upper left-hand corner as if I were tile printing, and planning on taping them together after printing.

Any solution for that in the MAC environment?

Works like a charm when I save as a pdf from my windows computer in Excel 2016.  In Windows, I can specify my 36x13 page size.  If I specify the page size in Windows Excel, save the file, and reopen it in MAC Excel, my page selection from the previous save is gone, and I am back to the same problem, with the limited page size options.

Answer 5

On a Mac I finally solved this problem by opening my Excel sheet in Numbers, Apple's spreadsheet software that reads and writes Excel files. Numbers ships installed on most Macs or can be purchased for a nominal price on the Mac App Store. 

Unlike Excel, Numbers easily prints to any paper size available on your printer. It's all handled right in the print dialog. Am printing a beautiful 17" x 22" spreadsheet right now.