Conditional page break if merged rows won't fit on the page.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a spreadsheet with groups of 2-8 rows merged in column A. Is
there a way to insert a conditional page break if a specific group of merged
cells won't fit together at the bottom of a page. I know page breaks can be
inserted manually, but I don't want to have to go back and adjust them all as
I add more data within the spreadsheet. Would some sort of macro work?
Thanks.
 
I don't believe conditional page breaks exist in Excel. You are right
however in that a Macro would do the trick. Try posting on the Excel
Programming forum. I'm afraid it would take me too long to put together an
example for you.

Bill Horton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping Rows Together 1
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Setting Page Breaks 10
Inserting page breaks 3
Access How to prevent subReport from breaking across pages? 1
Word 2007 Mail Merge / Directory & Section Breaks 2
How can I insert data into my spreadsheet without the page breaks. 1
Page Breaks And Merged Cells 3

Back
Top