Every once-in-a-while, I make the horrible mistake of accidentally clicking this demon-button in Excel, entering “Page Break Preview” mode:
And even after pressing the “Normal” button, the grid lines remain:
I don’t know about you guys, but I ALWAYS forget how to fix this, and it seems to change a little for every version of Office that rolls out, which frustrates me to no end. The following solution is valid for Excel 2016.
In Excel, click File, then Options:
Click Advanced and scroll about 3/4 of the way down the page until you get to “Display options for this worksheet”, and uncheck “Show page breaks”:/
All set!
Thank you! My OCD kicking in cause of this! I clicked that demon button out of curiosity and tried to revert it by clicking back to normal view and was surprised it remaind, and now I read your post and it was all good again! Thanks !
Thank you Megan!! These page breaks in Excel Office 365 were driving me crazy, and your guide helped me see the solution so quickly. I appreciate the graphics, and the quick concise explanation. I look forward to checking out your blog in the future.
Great, clear solution! Still valid in 2019. 🙂
Thank you so much! In the past I had always exited and restarted Excel for this. Your steps are still valid in Excel 365 ProPlus.
Thank you, this has always driven me insane when I’ve accidentally enabled it. Not sure why we have to have a big workaround, but I appreciate your straightforward and easy to follow solution nonetheless! Cheers!
This was insanely helpful, worked on Office 2013 as well.
Thank you so much for the help, I was going crazy trying to find this!
Thank you for this article! Also LOL describing Page Break Preview mode as a “demon button” is hilarious hahahahahah I loved this article
THANK YOU SO MUCH!!!
Thank you so much!
Still frustrating, for you have to do this routine for each new xls file.
I guess I did my last printing of an excel file four years ago, I really don’t understand why this could not be switched off by default and for all future new xls files.
I really don’t understand the benefit of this feature.