If you want to print a worksheet that is larger than one page, Excel divides it into pages by inserting automatic page breaks . These page breaks are based on paper size, margin settings, and scaling options you set. You can change which rows or columns are printed on the page by inserting horizontal or vertical page breaks . In page break preview, you can view the page breaks and move them by dragging them to a different location on the worksheet.
Insert a Page Break
Preview and Move a Page Break