Set Or Clear Print Area On Worksheet. On the Page Layout tab in the Page Setup group click Print Area and then click Set Print Area. 2 click Page Layout - Print Area - Clear Print Area.
Add cells to an existing print area. On the worksheet select the cells that you want to define as the print area. You should now be able to print the entire visible content of the worksheet from the Print menu.
Clearing the print area is as easy as setting it Open the worksheet of interest.
Select one sheet for instance sheet random password and then click Page Layout Print Area Clear Print Area. Check the 2 column width exceeding paper size. How to set or clear a print area in Excel Worksheet Set one or more print areas. Click the Print Area button then click the Clear Print Area option.