Read More: How to Change the Printing Scale So All Columns Will Print on a Single Page Method 2 – Using the Print Preview Screen to Fit to Page in Excel IStep 1: Go to the File tab. Step 2: Select Print. Choose No Scaling. Click Fit Sheet on One Page. Step 3: This is the ou...
.FitToPagesTall = 1 .Zoom = False End With ActiveSheet.PrintPreview End Sub We have declaredshtasWorksheetand set it to the worksheetSelection. UseSelection. Addressto set our selected range as the print area. Using theWITH statementwe defined different features of the printing area and usedAc...
Defining a print area gives you more control over what each printed page looks like and, ideally, you should always set a print area before sending a worksheet to the printer. Without it, you may end up with messy, hard to read pages where some important rows and columns are cut off, ...
Fit All Rows on One Page The above steps would scale the sheet to fit the page (based on what options you have selected). You will also be able to see how the data would look in the sheet preview which is on the right. The ‘Fit Sheet on One Page’ option is suited when you on...
1、在excel中选择需要打印的区域；2、在上方功能区中点击页面布局；3、在页面布局下点击打印区域—设置打印区域；在左上方的名称框中显示Print_Area【打印区域】；4、点击打印图标，进入打印预览页面，选择打印机，打印文档。在excel中设置打印区域后，在名称框中会显示Print_Area【打印区域】，当无需设置后，点击取消...
FirstPageNumber FitToPagesTall FitToPagesWide FooterMargin HeaderMargin LeftFooter LeftFooterPicture LeftHeader LeftHeaderPicture LeftMargin OddAndEvenPagesHeaderFooter Order Orientation Pages PaperSize Parent PrintArea PrintComments PrintErrors PrintGridlines PrintHeadings PrintNotes PrintQuality[] PrintTitleCo...
首先我们来了解一下打印区域。 Print_Area(表示打印区域) 首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打...
2. 设置打印区域的步骤 (Steps to Set Print Area) 2.1 打开Excel文件 (Opening the Excel File) 首先,打开你想要设置打印区域的Excel文件。确保文件中已经输入了你想要打印的数据。 2.2 选择打印区域 (Selecting the Print Area) 使用鼠标拖动选择你希望打印的单元格区域。可以是连续的单元格,也可以是多个不连续...
This tutorial demonstrates how to scale your print area to fit a page in Excel and Google Sheets. Scale to Fit Page To achieve a better fit on printed pages you can shrink or enlarge a worksheet. In the Ribbon, go to Page Layout and click the arrow in the lower-right corner of the ...
如果是手工取消 文件－打印区域—取消打印区域 即可取消 如果是想用VBA代码 ActiveSheet.PageSetup.PrintArea = ""即可 另外 Activesheet可以改换成Worksheets("Sheet1")这种形式