The paper size choices you see depend on the printer you use. Select whether you want a Portrait or Landscape orientation.Choose Page Layout> Page Setup> Orientation.To clear the Print Areaįrom this dialog box, select the cell addresses in the Print Area text box and press the Delete key. That you can reduce the Page Setup dialog box to just this text box by clicking its minimize box). The Print Area text box on the Sheet tab to insert the cursor and then select the cell range or ranges in the worksheet (remembering To define the Print Area from this dialog box, click You can also define and clear the Print Area from the Sheet tab of the Page Setup dialog box opened by clicking the Dialogīox launcher in the Page Setup group on in the Ribbon's Page Layout tab. Just have to click Print Area | Clear Print File on the Page Layout tab or simply press Alt+PRC. To clear the Print Area (and therefore go back to the printing defaults Excel establishes in the Print dialog box) you Print Areas check box and until you clear the Print Area. You can print (regardless of what other Print What options you select in the Print dialog box) unless you click the Ignore Whenever you fool with the Print Area, you need to keep in mind that after you define it, its cell range is the only one When you print the worksheet, only the area contained within the dotted lines prints. Dotted linesĪppear around the print area. Choose Page Layout> Page Setup> Print Area> Set Print Area.

Define dialog box launcher