"Louisa" wrote in message
...
Please help!

I have divided a worksheet into numerous pages using page breaks (around
70
page breaks per sheet, however they won't stay in place and sometimes when
I
move to another page and then go back they disappear. Any idea how I can
freeze/lock them in place? Sometimes it doesn't show them at all and when
I
try to insert another, it says there is one already there!I'm going nuts
please help!


personally I think 70 pages per single tab on a spreadsheet, is WAY, WAY too
many... I would put less breaks per tab, and add in a few more tabs. see if
there is some way to organize the data on the current sheet into more than
one tab, that way it is less info for the pc to keep track of all at once.
that could be one reason why the problems are happening, you are possibly
overloading excels ability to keep track of that many page breaks and the
associated data...
or
try clicking on the page break preview in the "View" menu... this will tell
excel to show the spread sheet pages with heavy SOLID blue lines for the
edges of the print area, and if it is multiple pages as you say, the breaks
between them will be in a heavy DASHED lines... then just to make sure, do a
print preview and click thru all pages to be printed, and adjust the
boundaries as needed to get the desired previews... they "should" stay there
as long as you don't drag the heavy blue lines anywhere else. realize of
course that if you add oh, say 10 lines/ rows/columns (whatever) to page
5... it will throw off all of the original breaks from page 5 all the way to
the end (pg 70) but leave the breaks from pages 1 to 4 ok... thus giving you
headaches in formatting the later page breaks to show exactly what you
want...