View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vic1 vic1 is offline
external usenet poster
 
Posts: 17
Default Fixing Page Breaks

I have a Workbook split into 26 alphabetical worksheets, each of which prints
out as several pages (300+ when the whole workbook is printed.)

I insert page breaks at the appropriate points and as long as I print there
and then, it is OK. However, if I save and close then reopen, the page breaks
have slipped and no longer 'break' in the right places - so they all have to
be set again, which is fairly time consuming on 300 pages!

Is there any means of fixing them so this does not happen?