On the keyboard, press Ctrl + J to enter the line break character NOTE: No text will appear in the Find What box just a small blinking dot.

Cells could have lots of new line feeds without them showing due to adjusted row heights. On the keyboard, press Ctrl + H to open the Find and Replace dialog box, with the Replace tab active.

See if there are any hidden rows or columns that could interfere (select all and Unhide both rows and columns) - if there are merged rows they could interfere with page layouts.

Make sure the font sizes and cell sizes are realistic by zooming to 100%.

Under View, select Page Layout view to see if there are any headers or footers taking up space.

While in Page Break Preview, you can drag a page break line right off the page to remove it.

The page break will move to the location where it is dragged. In the ribbon on the Insert tab, find the Page group. Place your mouse pointer over a page break line and drag. Follow these steps to insert the page breaks: Open your document, then insert the cursor at the end of the line before the section you want to start on a new page. Your page breaks will appear as heavy blue lines on your worksheet. Under Page Layout, look under Print Titles so that there are no Rows to repeat at top or left. Choose View, Page Break Preview from your Excel menu.Under Page Layout, check the Scale so that it doesn't affect the expected page breaks.

Under Page Layout, check Size so that it matches the print size, and also that it can fit the expected print area.

Under Page Layout, check Margins so that they arn't cropping the pages.

I come across this rather often from colleagues.В There are a few things to try:

Excel for mac 12 page breaks