How to create page breaks and page breaks in Excel

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.

How to create page breaks and page breaks in Excel Picture 1

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:

How to create page breaks and page breaks in Excel Picture 2

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:

How to create page breaks and page breaks in Excel Picture 3

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:

How to create page breaks and page breaks in Excel Picture 4

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:

How to create page breaks and page breaks in Excel Picture 5

Go to the View tab and select Page Break Preview display mode to check the results after page breaks:

How to create page breaks and page breaks in Excel Picture 6

Remove page breaks

To remove vertical page breaks, select the column at the page break position -> go to Page Layout -> Breaks -> Remove Page Break:

How to create page breaks and page breaks in Excel Picture 7

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:

How to create page breaks and page breaks in Excel Picture 8

As a result, you have removed the generated page breaks:

How to create page breaks and page breaks in Excel Picture 9

Above is how to create page breaks and page breaks in Excel hoping to help you. Good luck!