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

<TiredofSppam@hotmail.com> wrote in message
news:1150158570.627523.182890@j55g2000cwa.googlegroups.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
>