How To Set Page Breaks In Excel?

Open the worksheet in Excel

Go to the View tab

Click Page Break Preview

Select the row or column where you want the break

Go to the Page Layout tab

Click Breaks

Click Insert Page Break

To remove a break, go to Page Layout

Click Breaks

Click Remove Page Break

To reset all breaks, go to Page Layout

Click Breaks

Click Reset All Page Breaks

To adjust breaks manually, drag the blue page break lines in Page Break Preview

Suggested for You

Trending Today