The spreadsheet will be shown inPage Breakview. The cells that are set as the print area are marked as page 1. Method 3 – Set Multiple Print Areas in Excel Select the cells to be set as the print areas. Go toPrint Layout > Print Areaand selectSet Print Area. Select adjacent cells ...
设置打印区域的步骤 (Steps to Set Print Area),sizuzhibo.net, 1. 选择单元格 (Select the Cells) 首先,打开需要设置打印区域的Excel文件。在工作表中,使用鼠标选择要打印的单元格区域。可以选择一个连续的区域,也可以使用Ctrl键选择多个不连续的单元格。,xiaomanzhibo.com, 2. 访问页面布局选项卡 (Access the...
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...
After you set a print area in your Excel sheet, it will save automatically when you save your workbook. This allows you to quickly print that same spot without resetting the print area. How to View a Print Area Once you set up your print area, you may want to confirm you've selected ...
After that, go to the “Page Layout” tab, click on the “Print Area” icon, and then select “Add to the Print Area”.In the below “Page Break Preview”, you can see that Excel has expanded the print area selection where we have added adjacent cells and created an additional print...
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, ...
There you have it! By following these steps, you can efficiently set the print area inExcel, without printing the unnecessary information, at the same time making your printed documents moreorganizedandprofessional. If you like this Excel tip, please share it ...
If you have to print the same area on multiple sheets regularly, the use of VBA can speed up things. Set print area in selected sheets as on the active sheet This macro automatically sets the print area(s) for all selected worksheets the same as on the active sheet. When multiple sheets...
Note: Before performing the following actions, you need to make sure that a print area has been set up in the current worksheet. Seehow to set one or more print areas in a worksheet. Afterinstalling Kutools for Excel, go to theKutools Plustab, selectPrinting>Copy Page Setupto open the ...
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 new print area. In the second case, each print area in that worksheet will print as a separate page. In this example, you end up with two ...