The blue lined boxed area has been set as the print area. Read More: How to Set Print Area for Multiple Pages in Excel Method 5 – Set Print Area in Multiple Sheets Using VBA Press ALT+F11 to open the VBA window. In the VBA window, go to the Insert tab and select Module. Enter ...
A print area is a range of cells in Excel, you specify or make it fix for printing. So when you give a print command, it only prints that specific range. You can have multiple print areas in a single sheet and then save that file to save the print area and the file. In Excel, ...
In the ‘Page Setup’ group on the ‘Page Layout’ tab, you’ll find the ‘Print Area’ option. Click on it to reveal a dropdown menu, and then select ‘Set Print Area’. This action defines the selected cells as the print area. Excel will now recognize this range as the only part...
Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. Next, head to the Page Layout tab and pick "Set Print Area" in the Print Area drop-down box. When it's time to print, each print area will display on its own page. After you set...
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. ...
Clearing Print Area: If you want to remove the set print area, go to thePage Layouttab, click onPrint Area, and selectClear Print Area. Include Grid Lines in Printouts: If you want to include the grid lines in your printed copy, go to thePage Layouttab andtick the box for Printunder...
Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed.This technique could be useful if you want to print only a part of a report or there is a section of the report that you need to print often....
ThePage Setupdialogue box will show up. Here, from theSheeticon, click the arrow in thePrint Areabox. Assign the range of the print area. Close the dialogue box by clickingOK. Excel has set the print area already. Go to theViewtab> thenPage Break Viewand you will show the print area...
Setting a print area is simple and straightforward. Just open an Excel worksheet and highlight the cells you want to print. Click the “Print Area” option on the Page Layout tab, and in the “Page Setup” section select “Set Print Area.” ...
Step 2: Click theKutools>Show / Hide>Set Scroll Area. Then you will see only the selected print area is shown in current worksheet at once as below screen shot shown: Notes: Kutools for Excel’sSet Scroll Areasupports undo, and you can press theCtrl+Zkeys simultaneously to show hidden no...