First switch to the page break view and click on the cell to the left and upside of which you want to insert the page break.
You can also insert or remove the manual page breaks within the page break view by doing the below steps. Insert or Remove the Manual inserted Page Break In the above image, we have dragged the vertical dotted line to the end of header columns to print all the headers columns (A-J) on each page. If you want all the header columns of your data to be printed on each page, just drag the vertical dotted line to the end of the header columns.Click on the horizontal dotted page break line(s) and hold the mouse button and drag to the upside or downside place up to which you want the data to be printed on each page.Click on the vertical dotted page break line, hold the mouse button, and drag to the left or right place up to which column you want the data headers to be split for printing on each page.Here, you can see how your workbook data gets split on each page when you print.Once you click on “Page Break Preview”, Excel converts the normal view into page break view.First, go to the “View” tab, and under the “Workbook Views” group click on the “Page Break Preview” icon.
Page Break view shows the dotted lines to see where the data gets split to the next page.īefore printing the workbook data, every user wants to see how the data gets printed on each page, and for that, they can see it by changing the normal Excel view to page break view and can also adjust the page break selection as per their preference.īelow, we have captured some easy and quick steps for you on how to insert and remove the page break in Excel. It breaks and shows you the data to be printed on a single and each page to the end of your data.Įxcel page break splits the data based on multiple settings like page margin, scale, the size of the page, etc. Page break in Excel is a feature that splits or divides your worksheet data into separate pages for printing.