How to Set Print Area and Page Breaks in Excel
There are two ways to specify the workbook data that is printed: setting the print area and adjusting the page breaks.
Sometimes you may only want to print part of a worksheet. You can define an area so that any time you print, only that cell range is printed.
Once a print area is set, add additional print areas by selecting the additional cells, clicking the Print Area button, and selecting Add to Print Area.
A dark gray border appears around the print area. When you print, only the cells within that range appear on the page.
The print area is cleared and the entire worksheet will print once again.
Excel automatically breaks up the page based on the margins and other page settings, but it’s also possible to adjust these page breaks or add alternative breaks to divide a worksheet into separate pages for printing.
Click the Page Break Preview button on the status bar.
The worksheet appears in Page Break Preview view.
Dashed lines indicate automatic page breaks, while solid lines represent page breaks that you have changed or added.
Free to distribute with our compliments; we hope you will consider our paid training.