1、在excel中选择需要打印的区域；2、在上方功能区中点击页面布局；3、在页面布局下点击打印区域—设置打印区域；在左上方的名称框中显示Print_Area【打印区域】；4、点击打印图标，进入打印预览页面，选择打印机，打印文档。在excel中设置打印区域后，在名称框中会显示Print_Area【打印区域】，当无需设置后，点击取消...
首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打印。 设置动态打印区域 设置单元格区域打印之后,则会自动生...
RegionIndex- The print area region index for the page break.If the print area is continuous then there is only one print region. If the print area is non continous then there is more than one. This method drags a page break off the print area. You have to be in print preview mode f...
The print area in Excel is a designated range of cells that you specify to be printed, as opposed to printing an entire worksheet. This feature is incredibly useful for focusing on specific data or sections of your spreadsheet that you want to share or present, ensuring that only relevant in...
Fastest way to set print area in Excel The quickest way to set a constant print range is this: Select the part of the worksheet that you want to print. On thePage Layouttab, in thePage Setupgroup, clickPrint Area>Set Print Area. ...
How to set the print area in Excel Most times, we only want to print a part of our Excel worksheet, not its entirety. To do that, we need to first define or set a print area A print area is one or more ranges of cells in your sheet that you designate to print when you don...
如果是手工取消 文件－打印区域—取消打印区域 即可取消 如果是想用VBA代码 ActiveSheet.PageSetup.PrintArea = ""即可 另外 Activesheet可以改换成Worksheets("Sheet1")这种形式
问题: 用户指出,将法语或德语版Excel中的文件检入到Vault时,会弹出一个对话框,要求用户更改打印区域的名称: 名称已被使用。 该名称可能与预定义的名称不同。 旧名称:Print_area 新名称: 状态: 此事件已在以下产品中得到解决: ...
To extend an existing print area, select the cells you want to add, and in the Ribbon, go to Page Layout > Print Area > Add to Print Area.If you are adding adjacent cells, you will just enlarge the existing print area; but if you are adding non-adjacent cells, you will create a ...
Set a Print Area in ExcelIf you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook. To set a print area, execute the following steps. 1. Select a range of cells. 2. On the Page Layout tab, in the Page Setup group, ...