How to disable/remove page break preview in Excel

Hi Jrvs2018. Welcome to the forum.

If you are talking about the dotted lines that show up after Print Preview go to File > Options > Display options for this worksheet > uncheck Show page breaks.

I found it a pain to do all those steps every time this happened so I built a macro and assigned it to my Quick Access Toolbar.

Here's the code. It toggles those breaks off and on.

Please Login or Register  to view this content.

Not that I am aware of it, but it's late right now.

Give it a day or so. You've got a good thread title so if any one knows the answer for certain they are likely to see this.

Download a: Custom UI editor for Microsoft Office -> from Microsoft website

open the file with the UI editor
Click INSERT Button Choose option say : Office 2010 CUstom UI Part
there will be a name UI like : customui14.xml
click the window to the right then paste the code below

Formula:

Please Login or Register  to view this content.

toggle the enable to true or false

Note: Please mind the spaces.. Sucuri wont permit the code above