Page break specifies where a new page begins on the printer page.
There are two types of page breaks:
vertical and horizontal Vertical pages break separate columns, while horizontal pages break separate rows.
In this example, we'll insert a horizontal page break.
Step 1: Locate and select the Page Break view command. The worksheet will appear in Page Break view.
Step 2: Select the row below where you want the page break to appear. For example, if we want to insert a page break between rows 28 and 29,select row 29.
●Step 3: Click the Page Layout tab on the Ribbon, select the Breaks command, then click Insert Page Break.