To reduce scaling (Why is scaling bad?), it is then necessary to define custom paper size according to the size of the content. However, when you choose "Microsoft Print to PDF" as your active printer for Excel, there is no option for custom paper size.
This is what PDF Creator for Excel could help. It calculates the size of your content – the content could be the sheet, the selected range, or a chart, adds up the page margins, defines a proper custom paper, and then sends the content to the printer driver to generate the PDF file. There are no standard paper sizes involved.
PDF Creator for Excel supports a maximum size of 200 by 200 inches in size. This equals to 5080 by 5080 mm, or 14401.8 by 14401.8 points. That is, it always defines custom paper sizes within this range, and always tries to put the content within this size on a single page. Beyond this range, it allows to split the content to multiple pages.
PDF Creator for Excel uses margins defined using the Page Setup dialog box. To open the dialog box, go to Excel's "Page Layout" ribbon tab, click the arrow button on the right-bottom corner in the "Page Setup" group, and then go to the "Margins" tab.
PDF Creator for Excel respects all the margins defined on this page. It also uses the two "Center on page" options.