LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
page breaks ZWILLINGE Excel Discussion (Misc queries) 1 August 31st 05 08:55 PM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 04:33 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"