If you print a particular determination on a worksheet every now and again, you can characterize a print territory that incorporates only that choice. A print territory is at least one scopes of cells that you assign to print when you would prefer not to print the whole worksheet. When you print a worksheet in the wake of characterizing a print region, just the print region is printed. You can add cells to grow the print territory as required, and you can clear the print region to print the whole worksheet.
A worksheet can have different print zones. Each print region will print as a different page.
Set at least one print regions
- On the worksheet, select the cells that you need to characterize as the print territory.
- On the Page Layout tab, in the Page Setup gathering, click Print Area, and after that snap Set Print Area.
To see all the print territories to ensure they’re the ones you need, click View > Page Break Preview in the Workbook Views gathering. When you spare your exercise manual, the print region is spared as well.
Add cells to a current print region
You can expand the print region by including nearby cells. In the event that you add cells that aren’t contiguous the print territory, Excel makes another print region for those cells.
- On the worksheet, select the cells that you need to add to the current print territory.
- On the Page Layout tab, in the Page Setup gathering, click Print Area, and afterward click Add to Print Area.
Clear a print territory
- Snap anyplace on the worksheet for which you need to clear the print territory.
- On the Page Layout tab, in the Page Setup gathering, click Clear Print Area.