Floating Page Breaks
 

I have a report I do in Excel 2003, which gets broken into about 18
pages for supervisor and different 15 pages for dept heads when it's
printed and distributed. Each month I update the report by adding new
rows and deleting some old rows.

I've created custom views in the vain hope that that would save me the
work of inserting all those page breaks each month, but the breaks seem
to float around, I presume, because I'm adding and deleting rows.

Is there any way to anchor the page breaks so they won't float around?
I insert them on rows that contain sub-titles in the report. The
sub-titles don't change and remain each month. Only the rows below the
sub-titles will be added or deleted.

Can page breaks somhow be anchored to the sub-titles so they won't
float around?


Tired of breaking pages

Eldritch

Floating Page Breaks
 

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.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I have a report I do in Excel 2003, which gets broken into about 18
pages for supervisor and different 15 pages for dept heads when it's
printed and distributed. Each month I update the report by adding new
rows and deleting some old rows.

I've created custom views in the vain hope that that would save me the
work of inserting all those page breaks each month, but the breaks seem
to float around, I presume, because I'm adding and deleting rows.

Is there any way to anchor the page breaks so they won't float around?
I insert them on rows that contain sub-titles in the report. The
sub-titles don't change and remain each month. Only the rows below the
sub-titles will be added or deleted.

Can page breaks somhow be anchored to the sub-titles so they won't
float around?


Tired of breaking pages

Eldritch

Floating Page Breaks
 

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