|
How to insert page break automatically?
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 |
How to insert page break automatically?
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 |
How to insert page break automatically?
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 |
How to insert page break automatically?
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 |
| All times are GMT +1. The time now is 03:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com