1、在excel中选择需要打印的区域;2、在上方功能区中点击页面布局;3、在页面布局下点击打印区域—设置打印区域;在左上方的名称框中显示Print_Area【打印区域】;4、点击打印图标,进入打印预览页面,选择打印机,打印文档。在excel中设置打印区域后,在名称框中会显示Print_Area【打印区域】,当无需设置后,点击取消...
新的选择将覆盖之前的设置。 3.2 清除打印区域 (Clearing the Print Area) 如果你想要清除已设置的打印区域,可以在“页面布局”选项卡中点击“打印区域”按钮,然后选择“清除打印区域”。这样,整个工作表的打印区域设置将被清除,恢复为默认状态。 4. 使用打印区域的技巧 (Tips for Using Print Area) 4.1 使用命名...
首先我们来了解一下打印区域。 Print_Area(表示打印区域) 首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打印。
如果是手工取消 文件-打印区域—取消打印区域 即可取消 如果是想用VBA代码 ActiveSheet.PageSetup.PrintArea = ""即可 另外 Activesheet可以改换成Worksheets("Sheet1")这种形式
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. ...
Once you have selected your page break, click on theFiletab, selectPrint, and preview how your spreadsheet will look when printed. As you can see, the preview will show thepage breakin between rows 18 and 19. Additional Tips Clearing Print Area: If you want to remove the set print area...
But what if you want to print multiple areas in that same sheet? Can we set multiple print areas in Excel too? Of course! You’re definitely not limited to a single print area. Buckle up because that’s what you’ll learn next Kasper Langmann, Microsoft Office Specialist How to set...
How to Select the Cells to be Printed in Excel Selecting the desired cells to be printed is the first step in setting the print area. To do so, click and drag the mouse over the cells that need to be printed. Alternatively, hold down the Shift key and use the arrow keys to select ...
名称可以是内置名称(如“Database”、“Print_Area”和“Auto_Open”)或自定义名称。 NegativeBarFormat 代表由数据条的条件格式规则定义的、负值数据条的颜色设置。 ODBCConnection 代表ODBC 连接。 ODBCError 代表一个由最近的 ODBC 查询生成的 ODBC 错误。 ODBCErrors 对象的集合 ODBCError。 OLEDBConnection 代表...
How to center a worksheet in Excel How to select non-adjacent cells in Excel How to unhide a hidden workbook in Excel How to make Excel vertical text After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses...