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.
我有excel 2016，我做了一个大表格，我想在Din A1纸上“打印”出来。意思是我想先把它保存成pdf，然后发送到打印服务。
I have set the sheet to fit on one page in the "Page Setup" (see Screenshot).
我已经在“页面设置”(见屏幕截图)中设置为适合一个页面。
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:
接下来我想把它打印在A2或A1上，因此我从“纸张尺寸:”中选择了“管理定制尺寸…”-下拉菜单，并为Din A2和Din A1设置定制尺寸:
Though the result looks like this:
尽管结果是这样的:
As you can see, the sheet should cover the whole page, but it doesn't with this particular custom size.
正如您所看到的，这张表应该覆盖整个页面，但是它不包含这个特定的自定义大小。
Neither does it fit to any other custom size, which is above 297mm x 420mm, which is the supported DinA3 size.
它也不适合任何其他定制尺寸，超过297mm x 420mm，这是支持的DinA3尺寸。
When I use as a custom size 297mm x 420mm the sheet fits the page good, but even if the custom size is just 1mm off, the results breaks.
当我使用自定义尺寸297mm x 420mm时，纸张适合页面很好，但是即使自定义尺寸只有1mm，结果也会出错。
See the following example with 297mm x 421mm:
参见下面297mm×421mm的示例:
How do I print out this Excel Sheet on ONE custom page with a custom size? (Like Din A1 with 594mm x 841mm)
如何在一个自定义页面上打印这个Excel表格?(如Din A1, 594毫米x841毫米)
Thanks in advance.
提前谢谢。
Btw: I am on Mac. Not sure if it makes a difference.
顺便说一句:我用的是Mac电脑。我不确定这是否会有什么不同。
1 个解决方案
#1
1
You could try converting the pdf into an image, for example png then use a word processor to stretch the image as desired, without losing image quality that is
您可以尝试将pdf转换为图像，例如png，然后使用文字处理器按需要拉伸图像，而不会丢失图像质量
#1
1
You could try converting the pdf into an image, for example png then use a word processor to stretch the image as desired, without losing image quality that is
您可以尝试将pdf转换为图像，例如png，然后使用文字处理器按需要拉伸图像，而不会丢失图像质量