How can Excel adjust page breaks to specific locations?

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

Guest

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?
 
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
 
Back
Top