On theSheettab, put the cursor in thePrint areafield, and select one or more ranges in your worksheet. To select multiple ranges, please remember to hold theCtrlkey. ClickOK. Tips and notes: When you save the workbook, the print area is alsosaved. Whenever you send the worksheet to the...
To view the print area, go to the View tab and select Page Break Preview. The spreadsheet will be shown in Page Break view. 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...
Select the desired printed area. The Macro tab will open on the screen. Run to apply the code to the desired selected area. You will get the result below. Things to Remember The easiest method is the first method. In the case of method 3, remember that you have to print the area usi...
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...
How to View a Print Preview How to Clear a Print Area If you frequentlyprint a certain part of your spreadsheet, you can choose a designated print area in Microsoft Excel. This saves you from having to select it every time you want to print. We'll show you how. ...
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...
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”. ...
Excel offers a built-in feature “Set Print Area” for setting print areas, commonly used by many users. In this section, we'll guide you on how to apply this feature to set one or more print areas in an Excel worksheet. In a worksheet, select the range of cells you wish to set ...
Step 1: Select the print area in current worksheet. Note: If you can’t find out the print area quickly, you can pressF5key to open the Go To dialog box, select the print area name and click theOKbutton as below screen shot shown. But this method will select all print areas in cur...
How to Set a Print Area in Microsoft Excel Drag and select the cells that you want to define as the print area. Go to thePage Layouttab on the Ribbon. On thePage Setupgroup > clickPrint Area>Set Print Area. When you want to print multiple areas:Hold down the Ctrl key and click to...