Page Breaks And Merged Cells

[Jim Reed]

Hello!

In Excel 2003, I have a table in which the cells in Column A and Column C
are merged in groups of two rows each. For example, Cells A4 and A5 are
merged together, C4 and C5 are merged together, A6 and A7 are merged
together, C6 and C7 are merged together, etc. The cells in Columns B and D
are not merged.

Is there a way to have the page breaks automatically not occur in the middle
of a merged cell? I know how to adjust the page break locations manually.
I was hoping for a command similar to the "do not let rows break across a
page" function in Word, but I could not find one.

Thank you in advance for any assistance.

 

[Gord Dibben]

Excel has limited Word Processing functionality.

I know of no way to prevent a pagebreak in the middle of merged cells.

Manual seems to be the only way unless you went with VBA to seek out the merged
cells at a logical pagebreak point and place a pagebreak above or below.

"Logical" being the keyword.........you wouldn't want a pagebreak at every set
of merged cells.


Gord Dibben MS Excel MVP

 

[JE McGimpsey]

XL doesn't have anything like "do not let rows break".

Since merged cells usually cause more problems then they're worth, is
there a way you could do without them - e.g., use ALT-ENTER to put in a
line break within a cell?

 

[Jim Reed]

JE & Gord

Thank you for your replies. In this case, since my worksheets are fairly
small (2-3 pages at most), it will be easier to manually adjust the page
breaks a few times a year than to unmerge the cells.