This first technique explains how to use Excel’s Page Layout tab to clear the print area. Utilizing Page Layout Tab to Clear Print Area in Excel Let’s suppose we have a sample data set.ġ. We will demonstrate to you how to clear the print area in Excel by utilizing the Page Layout tab and applying VBA Code in the following two methods. However, if a worksheet has numerous sheets, each of which has a distinct print area, we need to simultaneously clear all the print areas across all the sheets.

In some circumstances, we might designate a worksheet’s print area for printing. Related Articles How to Clear Print Area in Excel: 2 Handy Approaches