How to "Print" Excel Sheet on Custom Page Size like Din A1?
<p>I have excel 2016 and I created a big sheet, and I want to "print" it out on Din A1 paper. Meaning that I want to save it as pdf first and sending it out to the printing service.</p>

<p>I have set the sheet to fit on one page in the "Page Setup" (see Screenshot).</p>

<p><a href="https://i.stack.imgur.com/Y0g79.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y0g79.png" alt="Page Setup"></a></p>

<p>Next I want to print it on A2 or A1, therefore I chose "Manage Custom Sizes..." from the "Paper Size:"-Dropdown and set the custom size for Din A2 and Din A1:</p>

<p><a href="https://i.stack.imgur.com/UdS7I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UdS7I.png" alt="Custom Page Size"></a></p>

<p>Though the result looks like this:</p>

<p><a href="https://i.stack.imgur.com/pFlk7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pFlk7.png" alt="Print Result"></a></p>

<p>As you can see, the sheet should cover the whole page, but it doesn't with this particular custom size.</p>

<p>Neither does it fit to any other custom size, which is above <strong>297mm x 420mm</strong>, which is the supported DinA3 size.</p>

<p>When I use as a custom size <strong>297mm x 420mm</strong> the sheet fits the page good, but even if the custom size is just <strong>1mm</strong> off, the results breaks.</p>

<p>See the following example with <strong>297mm x 421mm</strong>:</p>

<p><a href="https://i.stack.imgur.com/Xq2AR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xq2AR.png" alt="enter image description here"></a></p>

<p>How do I print out this Excel Sheet on ONE custom page with a custom size? (Like Din A1 with <strong>594mm x 841mm</strong>)</p>

<p>Thanks in advance.</p>

<p>Btw: I am on Mac. Not sure if it makes a difference.</p>