Master Excel Printing – All about Excel Print Areas
Table of Contents
- Create one or more print areas
- View a print area
- Add cells to an existing print area
- Clear a print area
- Related Articles
In most cases Excel spreesheets are very big and complex. When you want to print them, you only want to print selected areas, like results. This is easy in Excel. Let me show you how.
This applies to Excel 2013, Excel 2016, Excel 2019 and Excel 365.
- Multiple print areas are printed each on its own page.
- Print areas are unique to each worksheet. Different worksheets can have different print areas.
- Print areas are saved when you save the spreadsheet.
- Print areas are stored in named range called “Print_Area“ which is created for each worksheet.
Create multiple print areas by selecting many cell ranges you want to print in Step 1. You can do this by holding down the Ctrl key.
Select range which you want to set as print area
Go to Page Layout tab
Click Set Print Area item in Print Area
Created area will be visible as a light border around cells
By default, print areas are shown as an outlined boxes in the worksheet.
If your sheet is more graphically complicated those outlines might not be visible. In order to find where those areas are use Page Break Preview from View tab.
To go back click Normal
You can enlarge existing print areas by adding adjacent cells. It is done similarly to adding new area but instead you click add existing button.
Option to Add Print Area is visible only when you have an existing print area in the Excel worksheet.
If you click Set Print Area when there are existing areas, those areas will be cleared, and new area will be created.
Only adjacent cells added to existing print area will expand it. Cells which are not adjacent to any area will become separate print area printed as separate pages.
Select range of cells which you want to add to an existing area
Go to Page Layout, in Print Area options click Add to Print Area
As a result, the print area are will be extended
Clicking Clear Print Area clears all exsting areas in that worksheet!
Go to Page Layout, in Print Area options click Clear Print Area