分别为:PrintQuality、Orientation、FirstPageNumber、Zoom、FitToPagesWide、FitToPagesTall、PaperSize。 1、PrintQuality:返回或设置打印质量。Variant类型,可读写。此属性与“打印质量”选项对应。 Worksheets("Sheet1").PageSetup.PrintQuality = Array(240, 140)’用数组指定水平和垂直方向的打印质量 Worksheets("Sheet...
When printing an Excel spreadsheet, there’s typically white space at the page boundaries, ensuring a visually pleasing layout. However, with large worksheets, additional columns might spill onto a new page, along with extra rows. To fit the entire worksheet on a single page, make slight adjust...
The ‘Fit Sheet on One Page’ option is suited when you only have a few rows/columns that are spilling over. In case there are many, using this option may make the printed data too small to read. This doesn’t impact the worksheet data. It only scales the data for print purposes. ...
Go to the File tab. Step 2: Select Print. Choose No Scaling. Click Fit Sheet on One Page. Step 3: This is the output. Read More: Excel Fit to Page Scale/Preview Looks Small Method 3 – Applying a VBA Code to Fit to Page in Excel Step 1: Go to the Developer tab. Select Visu...
5.PrintQuality,返回或设置打印质量。 (来源:道客巴巴) 6.FirstPageNumber,返回或设置打印指定工作表时第一页的页号。默认值 xlAutomatic。 二:页边距 1.TopMargin,BottomMargin,LeftMargin,RightMargin,HeaderMargin,FooterMargin: 上、下、左、右页边距,以及页眉、页脚边距; ...
DifferentFirstPageHeaderFooter Draft EvenPage FirstPage FirstPageNumber FitToPagesTall FitToPagesWide FooterMargin HeaderMargin LeftFooter LeftFooterPicture LeftHeader LeftHeaderPicture LeftMargin OddAndEvenPagesHeaderFooter Order Orientation Pages PaperSize Parent PrintArea PrintComments PrintErrors ...
PC. However, Mac users may need to adjust the "Scale to Fit" settings slightly differently. To do this, click the "File" tab and select "Print." Click the "Scale" option and select "Fit Page." It will ensure that your Excel sheet fits on one page after you convert it to a PDF....
Remarks If this property is False, Microsoft Excel scales the worksheet according to the FitToPagesWide property. If the Zoom property is True, the FitToPagesTall property is ignored. Applies to ProductVersions Excel primary interop assembly Latest Feedback Was this page he...
FirstPageNumber 属性:返回或设置打印指定工作表时第一页的页号。 如果xlAutomatic, Microsoft Excel 将选择第一个页码。 默认值为 xlAutomatic。 Long 类型,可读写。 FitToPagesTall 属性 :返回或设置打印工作表时,对工作表进行缩放使用的页高。 仅应用于工作表。 读/写 Variant。如果此属性为False, Microsoft Exc...
Learn how to scale an Excel spreadsheet to fit on one page and how converting it to a PDF document can help you save paper and easily share the spreadsheet.