Select the cells on the worksheet that you wish to be the print area. Hold down the Ctrl key and click the locations you want to print while holding down the Ctrl key. Click Print Area, then Set Print Area, on the Page Layout tab, in the Page Setup group.