Excel Allows to apply the page breaks within the sheets, which sets the rows, or columns that will be part of a specific sheet. This option can be used to trim unwanted columns on the right or unwanted rows on the bottom.
The page breaks are applied automatically in Excel sheet. However, you can choose to set page breaks according to your requirement like when you want certain rows or columns at the end or beginning to be or not to be part of the current sheet.
Inserting Page Breaks
You can access the option for the Page Break listed in the drop down list, which appears on clicking the Breaks option listed under Page Layout Tab s shown below in the screenshot.
Insert vertical Page break First, place the mouse pointer anywhere in the first row. Then choose the option for Insert Page Break listed in the drop down list of Beaks under the Tab of Page Layout.
Removing Page Breaks