How to Print Excel Sheet on Custom Page Size like Din A1

0 votes

I made a large document in Excel 2016 that I want to "print" on Din A1 paper. I want to send it to the printing provider after first saving it as a pdf.

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

Page SetupI then selected "Manage Custom Sizes..." from the "Paper Size:" menu since I want to print it on A2 or A1. - Set the custom size for Din A2 and Din A1 using the drop-down menu:

Custom Page Size

Though the result looks like this:

Print Result

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

Neither does it fit any other custom size, which is above 297mm x 420mm, which is the supported DinA3 size.

When I use a custom size of 297mm x 420mm the sheet fits the page well, but even if the custom size is just 1mm off the results breaks.

See the following example with 297mm x 421mm:

enter image description here

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

Oct 10 in Others by Kithuzzz
• 20,660 points
111 views

1 answer to this question.

0 votes
Try turning the pdf file into an image, such a png file, and then using a word processor to expand the picture as needed without sacrificing image quality.
answered Oct 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
33 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
314 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
72 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
210 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

1-step shortcut to delete entire row in excel 2016

Highlight the whole row by clicking on ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer

ISBLANK returns False for empty cells having Formulas

ISBLANK will return TRUE only when a ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
46 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
131 views
0 votes
1 answer

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
86 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP