If you keep printing from the same area in a worksheet, you can set the print area in Excel.
You can find the option to set a print area in Excel from the Page Layout tab. Once you’ve assigned a print area, you can add to, or change the area entirely.
Additionally, Windows users can use a ribbon shortcut after selecting their range to create a print area.
Press, then let go of each of these keys to use the ribbon shortcut to set a print area in Excel:
Alternatively, to set a print area through ribbons, follow these steps:
- Launch Excel.
- Select your range.
- Head to Page Layout.
- Click Print Area > Set Print Area.
Ignore Adjacent Rows/Columns While Setting Print Area
While setting a print area, you may find the need to avoid unwanted or blank rows or columns. For such cases, you can Hide the specific rows/columns before setting the print area.
- Select the row/column you wish to ignore.
- Right-click and select Hide.
- Use the above-mentioned steps to set your print area.
Add New Area to Print Area
You can add a new area to the existing Print area. However, if the area is not adjacent to your existing print area, Excel prints it on a different page.
Remember to “add” to the area. If you select a range and set it as your print area, the area you previously allocated will be ignored.
- On your workbook, select the cell range.
- Select Page Layout from the menubar.
- Click Print Area > Add to Print Area.
Change the Print Area
If you’ve added a range you did not intend to print, you can remove it from the Page Setup window. Similarly, you can also enter ranges to add to the Print Area.
- Open your worksheet.
- Head to Page Layout.
- In the Page Setup section, click the expand icon.
- Select the Sheet tab.
- Add or delete your range in the Print area.
Clear the Print Area
When you’re done using the range as your Print area, you can simply clear it from the Page Layout tab.
- Head to Page Layout from your worksheet.
- Select Print Area.
- Choose Clear Print Area.
Ignore Print Area while Printing
You may not always find to print from the print area.
Excel, however, selects the print area by default when you try to print your values. When you wish to print the entire sheet, you will have to Ignore print area.
- Select Ctrl + P to head to the Print window.
- Click on the fly-out under Settings.
- Choose Ignore Print Area.