Method 3 – Adding Cells to Existing Printed Area Steps: Select the data you want to add in the printed area. Go toPage Layout>Print Area>Add to Print Areaoptions. Select thePage Break Previewfeature from theViewtab to show the data with desired page breaks. You will get the printed are...
Application.ScreenUpdating=FalseWithApplication.ActiveSheet.Cells.EntireColumn.Hidden=False.Cells.EntireRow.Hidden=FalseIf.PageSetup.PrintArea<>""ThenSetxPrintRng=.Range(.PageSetup.PrintArea)ElseSetxPrintRng=.UsedRangeEndIfSetxFirstRng=xPrintRng.Cells(1)SetxLastRng=xPrintRng.Cells(xPrintRng.Count)IfxFirstRng....
1、在excel中选择需要打印的区域；2、在上方功能区中点击页面布局；3、在页面布局下点击打印区域—设置打印区域；在左上方的名称框中显示Print_Area【打印区域】；4、点击打印图标，进入打印预览页面，选择打印机，打印文档。在excel中设置打印区域后，在名称框中会显示Print_Area【打印区域】，当无需设置后，点击取消...
Only show print area with VBA in Excel To hide non-printing area completely in Excel, you can try VBA macro. And you can do as follows: Step 1: Press theAlt+F11keys simultaneously to open the Microsoft Visual Basic for Applications window. ...
2. 设置打印区域的步骤 (Steps to Set Print Area) 2.1 打开Excel文件 (Opening the Excel File) 首先,打开你想要设置打印区域的Excel文件。确保文件中已经输入了你想要打印的数据。 2.2 选择打印区域 (Selecting the Print Area) 使用鼠标拖动选择你希望打印的单元格区域。可以是连续的单元格,也可以是多个不连续...
设置打印区域的步骤 (Steps to Set Print Area),sizuzhibo.net, 1. 选择单元格 (Select the Cells) 首先,打开需要设置打印区域的Excel文件。在工作表中,使用鼠标选择要打印的单元格区域。可以选择一个连续的区域,也可以使用Ctrl键选择多个不连续的单元格。,xiaomanzhibo.com, ...
首先我们来了解一下打印区域。 Print_Area(表示打印区域) 首先当我们Excel表格中有两个单元格时,我们将第一个单元格全选并命名为【Print_Area】,然后点击【页面布局】-【打印区域】-【取消打印区域】,则单元格区域中的内容名称Print_Area会消失不见。所以,我们只要重新定义Print_Area的单元格范围,就可将动态设置打...
如果是手工取消 文件－打印区域—取消打印区域 即可取消 如果是想用VBA代码 ActiveSheet.PageSetup.PrintArea = ""即可 另外 Activesheet可以改换成Worksheets("Sheet1")这种形式
You can download the practice workbook from here: Set Print Area Not Working.xlsx Related Articles How to Change Print Area in Excel How to Show Print Area in Excel How to Delete Extra Pages in Excel [Solved:] Print Area Is Grayed Out in Excel << Go Back toPage Setup|...
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...