This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a spreadsheet with merged cells. When I print, the merge cells break across the pages. Is there a way, short of writing a macro of manually inserting page breaks, to prevent Excel from breaking merged cells across pages when printing?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Right! So, there's no way to get Excel to treat those merged cells as a single larger cell, and keep those merged cells together when printing?
But my problem is that I AM getting a pagebreak in the middle of a vertically merged cell and I don't want it.
Apologies...............that was what I meant to say.............they allow breaks in the middle of the merged cells so you may have thought you built a larger cell, but it retains the single cells' attributes in this case.
My fingers did not type what I was thinking.
Gord
You cannot get a pagebreak in the middle of cells that are merged vertically. Just one more reason for me to state my usual..................merged cells are the spawn of Satan.
Gord