Menu
Cart 0

How to define a print area in Excel

Posted by Roger Hyttinen on

Excel allows you to define a specific print area that includes only the portion of the worksheet that you want to print. In order to set the print area, you first need to select the cell range. Note that if you select a non-contiguous cell range, each section that you select will be printed on a separate page.

To define a Print Area, follow these steps:

To Define a Print Area from the Page Layout tab

  1. Select the cell range that you want to define.
  2. Click the Page Layout tab on the Ribbon.
  3. Click the Print Area button on and click Set Print Area. Excel automatically creates a named range called “Print_Area”“. 

  4. When you’re ready to print, choose the Print_Area range from the Name box, click the File tab, click Print and then choose Print Selection from the Settings area of the Print pane.

  5. To clear a print area, click the Print Area button and choose Clear Print Area.

Another method for setting the print range is to select the cell range you want, click in the Name box and type in a name (something like Print_Range or Expenses for example). Then, when you want to print the range, load the named range, press Ctrl + P (or click the File tab and choose Print) and ensure that Print Selection is selected in the Print pane. This method allows you to define several different print ranges, each saved with its own unique name.

Looking for more Excel tips? Check out our new book Excel 2016: Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks


Share this post



← Older Post Newer Post →


Leave a comment

Please note, comments must be approved before they are published.