Page Breaks (Excel 2003)

I hope I can articulate this the way it is intended (Maybe it's why I couldn't find anything in the MSKB)

I have a report in Crystal that I export as Excel. (Client doesn't have Crystal and prefers Excel anyway)

When I open the (100 page) report in Page Break Preview, it is "off". So I have to manually manipulate
every page to fit. Each page brerak is moved 'up' the same amount of spaces to just under the footer.

Is there a way to just move the first page break line and have all subsequent page break lines move 'up' the same? I would love to do it one time instead of 100.

Re: Page Breaks (Excel 2003)

Just thought I'd chip this in...

If I create a dummy report in a new Excel sheet by entering numbers say, 1 to 1000 in column A, setting the print range to a1:h1000, and then previeving in Page Break Preview, then the page breaks I 'see' are dependant on the paper size selected for printing.
Changing the paper size from A4 to letter for example will cause the page breaks to adjust.
Is it just something like that??
Or does your report have 'hard page breaks' inserted?

Re: Page Breaks (Excel 2003)

Hi,

As well as adjusting page size you could try playing with the bottom or top margins (File, Page Setup, Margins) - try increasing the bottom margin by half an inch or 1 cm metric and see whether that makes any difference. With a little fiddling you may be able to get a suitable size.

Re: Page Breaks (Excel 2003)

Hi Michael,

If your report consists of data that are output to rows that are all of the same height, you might find that shortening all the row heights just a bit is all you need to get evrything to fit - without having to delete any lines. Usually, you can trim a bit off without clipping any characters. If characters do get clipped doing this, you could reduce the point size by 0.5pt.