How to insert page break automatically?

J

Jack

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
 
S

Stefi

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

Regards,
Stefi


„Jack†ezt írta:
 
J

Jack

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
 
S

Stefi

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

Regards,
Stefi

„Jack†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Turning off automatic calculation 0
Paragraph mark added on the top of every second page 3
Page break dosen't break 4
How do I insert page breaks in a huge EXCEL file? 4
Inserting page break 3
Mailmerge - page breaking to new customer 1
how to find time clashes using excel 6

Top