Page breaks between groups

[Rich]

I have a worksheet with around 3000 records. which I need
to pagebreak between groups. I added subtotals with
the "at each change in", "use function", "add subtotal to"
and ticked the page break between groups. Subtotals come
out fine but it will not apply the page breaks. I tried
replacing current subtotals but still no good. Whats going
on?

thanks
Rich

 

[Jim Rech]

Check File, Page Setup. If you have "Fit to" selected on the Page tab then
Excel ignores manual page breaks. Change it to "Adjust to".

 

[Rich]

Thanks, this solves the problem!

Rich