How can Excel adjust page breaks to specific locations?
 

My office uses Excel to track comments and responses to client concerns. The
comments and responses are on separate rows. As the responses are
ever-changing, the page break locations change as well. We do not want page
breaks between the comment and response. Is there a way to 'tell' Excel where
page breaks are accepable?

How can Excel adjust page breaks to specific locations?
 

If there is is a logical place to insert a manual pagebreak it can be done
through VBA.

What would be a logical and repeatable spot to insert a break?

After a certain phrase or after the row below a cell with a Comment?


Gord Dibben MS Excel MVP

On Mon, 24 Sep 2007 07:38:01 -0700, Kara Strong
wrote:

My office uses Excel to track comments and responses to client concerns. The
comments and responses are on separate rows. As the responses are
ever-changing, the page break locations change as well. We do not want page
breaks between the comment and response. Is there a way to 'tell' Excel where
page breaks are accepable?