Tom Ogilvy wrote:
If you select a cell where you want the pagebreak above it, and do

Insert=PageBreak

that will insert a manual pagebreak and if you don't delete this row, then
it should remain in place.

That said if you alter your sheets so that the height between two manual
pagebreaks exceeds what the printer can print, then an automatic pagebreak
will be place where the printer's ability needs it.


Thanks Tom.

My page breaks are definitely moving around. Most of the pages I
define for the supervisors run no more than 5 or 6 lines. So automatic
breaks due to length doesn't seem to be an issue her.

I sort the report several times during the its preparation. Would
sorting cause the page breaks to move to other lines/rows? If so, any
way to prevent it?

Eldritch