Forum Discussion
Preventing automatic page breaks in Excel 365
If you insert a break before the automatic one, that in effect removes the automatic one. You say it's a two page worksheet and are complaining--presumably--that the automatic one isn't where you want it. The automatic one comes when the data will no longer fit on the first page. If you just put a "manual" one in before that, the automatic won't still happen, not at the same place at any rate.
Point being it's possible for you to be in control.
There's also an ability to change the whole page setup so that all two pages are compressed to fit on a single page. That's not what you want, I'm pretty sure, but it supports the contention that you DO have control over how things are displayed,
mathetesA colleague sent me a spread sheet we've been using for years. It consists of 2 landscape formatted pages each with a formatted table containing several columns adjusted to fit the page. That's what I loaded into MS365's version of outlook. What appeared on the screen was a totally reformatted mess with overhanging margins, extra page breaks etc. Following the directions I chose columns close to the page break and tried to remove it, no luck.
Perhaps a spreadsheet generated in an older version of Excel is incompatible?