Inserting manual breaks into the worksheet in Microsoft Excel 2019

  1. Make sure you are in Page Breakview by clicking on the View tab.
  2. Choose Page Break Preview from theWorkbook Views group.
  3. Select a cell to insert the page break above it, and then click toselect the Page Layout tab.
  4. From the Page Setup group, selectthe Breaks icon to access thedrop-down list menu.
  1. Select Insert Page Break. A solidline appears on the worksheet, indicating a manual page break.
To remove a page break, click on the PageLayout tab. Click on the Breaksicon and select the Remove Page Breakoption from the drop-down list.

Leave a Comment