Set Print Area On Worksheet. Click the Print Area option on the Page Layout tab and in the Page Setup section select Set Print Area Keep in mind that the print area will be saved once you save the workbook. On the Page Layout tab in the Page Setup group click Print Area Set Print Area.
This example sets the print area to cells A1C5 on Sheet1. Just open an Excel worksheet and highlight the cells you want to print. Go to the Page Layout tab.
Each print area gets a.
Double click on the Worksheet where you want to set your Print Area. Set or clear a print area on a worksheet ExcelIf you print a specific selection on a worksheet frequently you can define a print area that includes just tha. This property applies only to worksheet pages. To set more than one print area hold down the Ctrl key and select the areas you want to print.