Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Set and Clear the Print Area in Excel 2016

Date:2019-8-9 Author:Olivia

Sometimes you may not want to print the entire form, is there any method to define the specific print area of your need? Here I’ d like to share the tip of setting and clearing the print area in Excel.

First, select all texts you want to set as the print area.

How to Set and Clear the Print Area in Excel 2016

Then, find Page Layout tab, click Print Area in Page Setup section.

How to Set and Clear the Print Area in Excel 2016

Just click Set Print Area and you are done.

Note: If you want add other texts to the existing print area, simply select them and click Add to Print Area. If you want to remove some texts from the existing print area, select them and click Clear Print Area.

How to Set and Clear the Print Area in Excel 2016

Want to check before printing? You can find View tab, click Page Break Preview in Workbook Views section. What’s framed in blue is the setting up print area.

How to Set and Clear the Print Area in Excel 2016

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *