How did you remove Subtotals? I guess you deleted them selecting Subtotal
rows one by one.
Use DataSubtotalsRemove all button (bottom left button in the Subtotals
dialog)!

Regards,
Stefi

€žJack€� ezt Ã*rta:

Hi, Stefi,

I tried. But when I remove Subtotals, the page breaks were left but were
not in the correct positions. Just as illustrated in the example below.

Maybe the way I removed the breaks is wrong. Could you please advice the
correct way to remove the subtotalls and leave the breaks where they were.

Tom
Tom
Mary

Mary
Mary
John

John
John
--
Jack


"Stefi" wrote:

I found that DataSubtotals can insert page breaks. If you remove Subtotals,
page breaks remain.

Regards,
Stefi


€žJack€� ezt Ã*rta:

Hi, Excel stars,

anyone knows how to insert page breaks automatically whenever the item in
the colume changes? Please see the sample below.

Name
Tom
Tom
Jack
Jack
Mary
Mary
--
Thanks in advance for your answer!

Jack