Page breaks in Excel make it easy to choose to print an area or any data range. In this article, you can create page breaks and page breaks on Excel spreadsheets to help you print easily.
Page break by column (vertical page)
- Select the position of the column to break into a new page -> go to Page Layout -> Breaks -> Insert Page Break:
With a simple operation, you can break the page as you like. To check if the page break results or not, go to the View tab and select Page Break Preview mode to see the results of the broken page highlighted in purple border:
Or you choose the Page Layout mode you will see from the position the data column you want to break is pushed to the new page:
Page break in row (horizontal page break)
Because the number of records is too large, you want to choose a new page position according to the order of page breaks in rows to help you solve this problem.
Select the position of the row to break page -> go to Page Layout -> Breaks -> Insert Page Break:
Go to the View tab and select Page Break Preview display mode to check the results after page breaks:
Remove page breaks
To remove vertical page breaks, select the column at the page break position -> go to Page Layout -> Breaks -> Remove Page Break:
To remove horizontal page breaks, you select the row at the page break position -> go to the tab on Page Layout -> Breaks -> Remove Page Break:
As a result, you have removed the generated page breaks:
Above is how to create page breaks and page breaks in Excel hoping to help you. Good luck!