Forum Discussion
Preventing automatic page breaks in Excel 365
I've a 2 page worksheet but excel generated a multipage document automatically which according to the help files cannot be removed. How do I prevent that from happening in the first place. In other versions of excel I could easily place page breaks where I wanted them?
6 Replies
- The Insert menu still has a page break option for you to do this manually.
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,
