Home > Google

Google Sheets Set Custom Page Break not working: How to Fix

In this guide, we will be discussing a plausible method that might help you fix the Set Custom Page Break feature not working in Google Sheets. Whether this spreadsheet program from the Silicon Valley giants is better than the offering from the Redmond giants is always up for debate, what isn’t is the fact that it is the best tool in the online domain. Beholding all the required feature sets (and not costing a dime), there’s not much left to ask for.

Google Sheets Set Custom Page Break not working

Apart from the fact that it doesn’t end up getting bugged at regular intervals, something that is happening at this instance as well. As of now, various users have voiced their concern that the page break functionality is not working along the expected lines. Since Sheets doesn’t segregate the pages unlike other word processors tools, taking a printout of such documents is causing a great deal of inconvenience to the end-users.

Google Sheets Set Custom Page Break not working

Whenever users are trying to add a page break at the desired location, it doesn’t get added there but randomly gets allocated to any other position. And even the drag and drop action isn’t doing any good. So is there any way to fix the Set Custom Page Break not working in Google Sheets? Well, there does exist a workaround that has spelled out a variable degree of success to some users. So without any further ado, let’s check it out.

How to Fix Google Sheets Set Custom Page Break not working

Google Sheets Set Custom Page Break not working

Most of the users who were facing this issue had one thing in common- their sheet was having a few hidden rows. if that is the case with your sheet as well, then try moving those hidden rows to the bottom of your sheet. After that, go to File > Print > Custom Page Breaks > Edit and check if the underlying issue has been resolved or not.

Google Sheets Set Custom Page Break not working

So this was all from this guide on how you could fix the Set Custom Page Break not working in Google Sheets. As far as the official stance on this matter is concerned, the developers are aware of this issue, but they haven’t given out any ETA for the rollout of a fix. As and when that happens, we will update this guide accordingly. In the meantime, the aforementioned workaround is your best bet.


Share: