Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
page breaks | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |