1、在excel中选择需要打印的区域；2、在上方功能区中点击页面布局；3、在页面布局下点击打印区域—设置打印区域；在左上方的名称框中显示Print_Area【打印区域】；4、点击打印图标，进入打印预览页面，选择打印机，打印文档。在excel中设置打印区域后，在名称框中会显示Print_Area【打印区域】，当无需设置后，点击取消...
Excel offers a built-in feature “Set Print Area” for setting print areas, commonly used by many users. In this section, we'll guide you on how to apply this feature to set one or more print areas in an Excel worksheet. In a worksheet, select the range of cells you wish to set ...
SubPrint_Area()DimPrintAreaAsRangeDimPrintAreaAddressAsStringDimSheetAsWorksheetOnErrorResumeNextSetPrintArea=Application.InputBox(" Select a Range for Print Area",Type:=8)IfNotPrintAreaIsNothingThenPrintAreaAddress=PrintArea.Address(True,True,xlA1,False)ForEachSheetInActiveWindow.SelectedSheets Sheet.PageSetup...
How to set multiple print areas in Excel To print a few different parts of a worksheet, you can select multiple print areas in this way: Select the first range, hold down theCtrlkey and select other ranges. On thePage Layouttab, in thePage Setupgroup, clickPrint Area>Set Print Area. ...
首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打印。
Excel 2016 If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you pr...
是否中病毒，可以用金山毒霸等杀毒软件来扫描。如果金山毒霸确认无毒，就不是病毒了。建议你关闭excel，然后重新打开试试。
Fast Way To Select Print Area In Excel
If you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook.
How to Set a Print Area in Microsoft Excel Drag and select the cells that you want to define as the print area. Go to thePage Layouttab on the Ribbon. On thePage Setupgroup > clickPrint Area>Set Print Area. When you want to print multiple areas:Hold down the Ctrl key and click to...