Manual page break not working in Excel

I struck an interesting problem in Excel recently, where I was unable to manually insert a page break. it took me some time to track the actual problem down.

In seeking an answer, initially I went down many rabbit holes: whether the issue was merged cells, whether it was related to drag-and-drop and the Enable fill handle and cell drag-and-drop box being ticked in advanced options, or whether I was trying to insert the break in the right row. However, none of these known issues applied.

What was preventing me from inserting a page break was actually page scaling: I had set my print size to one page wide by four pages long. In that document format you are unable to manually insert a page break. Who knew?

To solve it, all you need to do is set scaling as a percentage for the worksheet.

Easy when you know how.


Sam