1、在excel中选择需要打印的区域；2、在上方功能区中点击页面布局；3、在页面布局下点击打印区域—设置打印区域；在左上方的名称框中显示Print_Area【打印区域】；4、点击打印图标，进入打印预览页面，选择打印机，打印文档。在excel中设置打印区域后，在名称框中会显示Print_Area【打印区域】，当无需设置后，点击取消...
Demo: only show print area in a worksheet in Excel Related articles: Set scroll position or hide other cells Show hidden ranges (columns and rows) Hide other sheets 🤖Kutools AI Aide: Revolutionize data analysis based on:Intelligent Execution|Generate Code|Create Custom Formulas|Analyze Data and...
Now, a dark gray border appears around the print area. See screenshot: After designating the selected range as a print area, only this area will be printed by default when you print the worksheet. Tip: When setting multiple print areas in an Excel sheet, they will be printed on separate...
SubPrint_Area()DimPrintAreaAsRangeDimPrintAreaAddressAsStringDimSheetAsWorksheetOnErrorResumeNextSetPrintArea=Application.InputBox(" Select a Range for Print Area",Type:=8)IfNotPrintAreaIsNothingThenPrintAreaAddress=PrintArea.Address(True,True,xlA1,False)ForEachSheetInActiveWindow.SelectedSheets Sheet.PageSetup...
Excel print area Aprint areais a range of cells to be included in the final printout. In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. When you pressCtrl + Por click thePrintbutton on a sheet that has a defined print area, ...
是否中病毒，可以用金山毒霸等杀毒软件来扫描。如果金山毒霸确认无毒，就不是病毒了。建议你关闭excel，然后重新打开试试。
Print_Area(表示打印区域) 首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打印。
Print_Area是打印区域的意思，如果工作表制订了打印区域就会在工作表的名称管理器里自动定义了这个名称，可以手动删除
Excel saves the print area together with the workbook. Select the cells that you want to print. On theFilemenu, point toPrint Area, and then clickSet Print Area. On theFilemenu, clickPrint. Add cells to an existing print area Select the cells that you want to add to the e...
If you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook.