Forum Discussion
Preventing automatic page breaks in Excel 365
mathetes but that works only for breaks you have inserted, not those inserted automatically.
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,
- Thanks, I think the problem occurred when I sent the file to my boss who added sum numbers in Apples version of Excel, saved it as an Excel file and returned it to me. Something happened along the way. I've asked him to take a good look at the formating in his machine and assure it is correct before saving it.
Thanks, I'll let you know how it all works out!
