Often an Excel worksheet is just a bit too wide to print on one page. You could change it to Landscape orientation, so more will fit across, but you may prefer to keep it in Portrait orientation, especially if it's a long list.
通常,Excel工作表的宽度有点太宽而无法在一页上打印。 您可以将其更改为“横向”,这样可以适应更多情况,但是您可能更希望将其保持在“纵向”,特别是在列表较长的情况下。
In Excel's Page Setup dialog box, you can adjust the scaling so the sheet will fit across on one page.
在Excel的“页面设置”对话框中,您可以调整缩放比例,以使图纸可以跨一页显示。
- On the Page tab, click the 'Fit to' option for Scaling. 在页面选项卡上,单击缩放的“适合”选项。
- Enter 1 as the number of page(s) wide. 输入1作为全页数。
- Clear the box for the number of pages tall, then click OK. 清除高页数框,然后单击“确定”。
This will limit the file to printing one page across, but won't limit the number of pages down.
这将限制文件只能打印一页,但不会限制向下打印的页数。
You don't have to guess the number of pages required, just leave it blank and Excel will figure it out for you. _____________
您不必猜测所需的页面数,只需将其保留为空白,Excel就会为您解决。 ______________
翻译自: https://contexturesblog.com/archives/2009/01/09/print-an-excel-sheet-on-one-page/