How To Set Print Area In Excel 2013

With the help of the paste special feature you can link the copied ranges to the original data in this way.

How to set print area in excel 2013. Use your mouse to highlight the cells that will be the print area. If you frequently print a specific section of your worksheet you can set a print area for it. Each print area gets a. Choose set print area.

Click next in step 2 of the wizad check specify new print. Choose set print area. Open your file in excel 2013. In the page setup group click.

On a new sheet right click any blank cell and choose paste special linked picture. To set more than one print area hold down the ctrl key and select the areas you want to print. Select the cells that you want to print. Click the print area icon in the page setup group.

Open the file containing the cells that you want to set as a print area. Set one or more excel print areas open a worksheet and select the cells that you want to be part of the print area. Click the file tab and then click print. Classic menu for office restores old toolbars of microsoft excel 2003 in microsoft excel 20072010201320162019 ribbon under menus tab.

Go to the page layout tab. To set a print area execute the following steps. Select a range of cells. Repeat steps 1 and 2 for other print areas.

Click the print area. Click the page layout tab. You can enlarge the print area by adding adjacent cells. That way when you print your worksheet only that section will print.

Click the page layout tab at the top of the window. Excel will print blank cells if they are included in a print area so this can be a helpful solution if you need to print out a blank grid and complete it manually such as when doing a physical inventory. Set print area from toolbar if you have classic menu for office. Highlight the cells that you want to set as the print area.

Select the first print area and press ctrl c to copy it. On the old toolbar click the drop down button beside the print setup button and you will get the set print area sooner. Click kutools plus printing print multiple selection wizard. How to resize print area and fit to one page in excel.

Click the page layout tab at the top of the window. Here is how to set the print area in excel 2013 step 1.