Select Print_Area from the Macro name box and click on Run. Select the cells to be set as print areas and click OK in the Input window. Excel will set the selected cells of this sheet as the print area. This Macro will also allow the user to set a cell range from multiple sheets ...
Hold down theCtrlkey and highlight as many groups of cells that you want to make into print areas. Using theCtrl key enables you to highlightdifferent areas without losing the initial range. Once you highlight your selected areas, click on theFiletab, selectPrint, and preview how your sprea...
设置打印区域的步骤 (Steps to Set Print Area),sizuzhibo.net, 1. 选择单元格 (Select the Cells) 首先,打开需要设置打印区域的Excel文件。在工作表中,使用鼠标选择要打印的单元格区域。可以选择一个连续的区域,也可以使用Ctrl键选择多个不连续的单元格。,xiaomanzhibo.com, 2. 访问页面布局选项卡 (Access the...
Set print range in all worksheets as on the active sheet No matter how many sheets you have, this code defines the print range in a whole workbook in one go. Simply, set the desired print area(s) on the active sheet and run the macro: SubSetPrintAreaAllSheets()DimCurrentPrintAreaAsString...
Step 1: Open Your Excel Workbook Begin by opening the Excel file that contains the data you wish to print. Ensure you are on the worksheet that has the data you want to set as the printable area. Step 2: Select the Data Range
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...
Steps to Set the Print Area in Excel First, select the single or multiple cell range using the “Control” key to set a print area in the sheet. Afterward, go to the “Page Layout” tab and click the “Print Area” icon. In the print dropdown, click on the “Set Print Area”. ...
Luckily there is a feature in Microsoft Excel called a print area where you can select some of the cells in the worksheet and have Excel just print those cells. Our tutorial below will show you how to set an Excel print area on a Mac so that you can reduce the amount you print. ...
Select the macro Print_Multiple_Range_in_One_Page and click the Run button. The printing will automatically begin. The selected ranges are printed on the same page like this: Read More: How to Print Specific Sheets Using VBA Macro in Excel Example 4 – Set Multiple Ranges From Multiple Shee...
1. Select a range of cells. 2. On the Page Layout tab, in the Page Setup group, click Print Area. 3. Click Set Print Area. 4. Save, close and reopen the Excel file. 5. On the File tab, click Print. Result: only the print area will be printed. See the print preview below. ...